topic Re: Row to Column in QlikView

Row to Column

manojkulkarni — Wed, 18 Nov 2015 08:01:15 GMT

Hi All,

I am having data in below format, would like to convert into Columns. Please suggest how to acheive.

expected result :

marcus_sommer — Wed, 18 Nov 2015 08:14:23 GMT

Have a look here: The Generic Load

- Marcus

Mark_Little — Wed, 18 Nov 2015 08:18:22 GMT

Hi,

I was going to suggest looking at the cross table option. But I think Marcus's option is better.

Also like to thank Marcus for pointing it out and the good blog post by Henric.

Mark

neha_sri — Wed, 18 Nov 2015 08:20:27 GMT

Hi Manoj,

Please use below script.

Generic LOAD [User ID],
Segment,
Bills
FROM

(ooxml, embedded labels, table is Sheet7);

manojkulkarni — Wed, 18 Nov 2015 13:24:14 GMT

Thanks Marcus. It worked

manojkulkarni — Wed, 18 Nov 2015 13:25:05 GMT

Thanks for your suggestion