How to convert cross table into straight table

[shruthibk]

Hi,

I have raw data available in a cross table format, now I want to load this cross table as straight table in QlikView.

Please guide me to perform this.

Thanks,

shruthi

[oknotsen]

Assuming you are calling the top row "Year" and the values "Value", add this line directly ABOVE your load statement:

CrossTable(Year, Value, 0)

[prma7799]

CrossTable(Year, Data, 0)

LOAD [2012],

     [2013],

     [2014]

FROM..........

[prma7799]

PFA...

[shruthibk]

Hi,thanks for your response but it is not giving the expected result.It is loading the data as it is.

expected output is

Year,Value

2012,10

2013,20

2014,30

2012,20

2013,30

2014,40

2012,40

2013,50

2014,60

thanks,

shruthi

[shruthibk]

[prma7799]

Can you please send some sample qvw file.

[oknotsen · Accepted solution]

Interesting. You seemed to have found a bug.

I created a work-around. This script (tested) does the trick:

YourTable:
CrossTable(Year, Data, 1)
LOAD 1 as BogusField,
[2012],
[2013],
[2014]
FROM
CrossTable.xlsx
(ooxml, embedded labels, table is Sheet1);

drop field BogusField;

[shruthibk]

thanks,this code is working

[prma7799]

Hi Shruti,

Just try okg  Solution

Thanks