Let's say I have a table called d_gift. The table includes the following fields:
d_giftkey, d_giftdate, d_gifttype and d_giftamount. A person can make multiple gift transactions which means the data would show vertically based on the number of transactions. Is there a way syntax wise to set up a view that will allow for vertical display of the data to look like this:
211111,12/21/2001,gift,$250, 3115,12/8/2004,payment,$1000
as opposed to:
211111,12/21/2001,gift,$250
3115,12/8/2004,payment,$1000
d_giftkey, d_giftdate, d_gifttype and d_giftamount. A person can make multiple gift transactions which means the data would show vertically based on the number of transactions. Is there a way syntax wise to set up a view that will allow for vertical display of the data to look like this:
211111,12/21/2001,gift,$250, 3115,12/8/2004,payment,$1000
as opposed to:
211111,12/21/2001,gift,$250
3115,12/8/2004,payment,$1000