topic Re: Convert few columns into rows during data load in QlikView

Convert few columns into rows during data load

Tue, 11 Feb 2014 15:42:55 GMT

How to convert some columns in table into rows?

I want to convert the above table as below during the load

Thanks in Advance

hic — Tue, 11 Feb 2014 15:46:54 GMT

Generic Load ProductID, [Product Type], [Sale Date] From ...

Then you can create the needed table as a straight table of table box.

HIC

Tue, 11 Feb 2014 15:50:23 GMT

I want to join the converted table with another table based on Product ID.I need to do it in data model not in UI.

Tue, 11 Feb 2014 16:01:39 GMT

I tried generic load it is creating table with duplicate Product ID's.May be because of Same Sale date for some product types?