How to get data from multiple columns into one?

Wed, 20 Aug 2014 13:19:33 GMT

Hi,

I have a problem with my data. I have a budget table in our ERP system with the following structure

Account	Value Period 1	Value Period 2	Value Period 3	Value Period 4	Value Period 5	Value Period 6	Value Period 7	Value Period 8	Value Period 9	Value Period 10	Value Period 11	Value Period 12
12345	10	20	30	40	50	70	90	100	110	120

I would need to change the data structure so that I would have all values in same column that I am able to use that in my report, like following

Any idea what kind of script woul do this data conversion for me?

Thanks

Regadrs

Janne Vauhkonen

Re: How to get data from multiple columns into one?

Gysbert_Wassenaar — Wed, 20 Aug 2014 13:22:14 GMT

You can use the crosstable function:

MyTable:

CrossTable(Period, Value)

LOAD * FROM ...my_erp_source...;

amit_saini — Wed, 20 Aug 2014 13:31:39 GMT

Hi Janne,

As Gysbert suggested, Crosstable concept will work here. Please see the attachment.

Thanks,
AS