Discussion board where members can get started with QlikView.
I am having data in below format, would like to convert into Columns. Please suggest how to acheive.
expected result :
Have a look here: The Generic Load
View solution in original post
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.
Please use below script.
Generic LOAD [User ID], Segment, BillsFROM(ooxml, embedded labels, table is Sheet7);
Thanks Marcus. It worked
Thanks for your suggestion