Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get data from multiple columns into one?

Hi,

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

AccountValue Period 1Value Period 2Value Period 3Value Period 4Value Period 5Value Period 6Value Period 7Value Period 8Value Period 9Value Period 10Value Period 11Value Period 12
1234510203040507090100110120

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

AccountPeriodValue

12345

110
12345220
12345330
12345440
12345550
12345660
12345770
12345880
12345990
1234510100
1234511110
1234512120

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

Thanks

Regadrs

Janne Vauhkonen

2 Replies
Gysbert_Wassenaar

You can use the crosstable function:

MyTable:

CrossTable(Period, Value)

LOAD * FROM ...my_erp_source...;


talk is cheap, supply exceeds demand
amit_saini
Master III
Master III

Hi Janne,

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

Thanks,
AS