topic Load and Unpivot a Spreadsheet Help in QlikView

Load and Unpivot a Spreadsheet Help

Thu, 08 Nov 2012 15:04:18 GMT

I am trying to load a spreadsheet in the form

Atr1 Atr2 Atr3 Date1 Date2 Date3 where the dates change each month.

A B C 50 50 50

Ideally I want to make this a rowset that looks like

A B C Date1 50

A B C Date2 50

A B C Date3 50

While having the load script identify the date coloumns dynamically and making them an attribute.

I know I can do multiple load scripts but do not know how to reference the column header dynamically.

The example attached has the source form and the desired resulting form.

Any help is appreciated..

Thanks

MayilVahanan — Thu, 08 Nov 2012 15:08:36 GMT

CrossTable(Month,values,6)

LOAD * INLINE [

Project, Project ID, Resource ID, Resource, Investment Role, Investment, Jan 12, Feb 12, Mar 12, Apr 12, May 12, Jun 12, Jul 12

Lawson - Purge/Archive, PMO-00000196, 302006, "Alexander, Jordan", BA - LAW, Lawson - Purge/Archive, 17.60, 16.80, 17.60, 16.80, 18.40, 16.80, 16.00

];

Hope it helps

Thu, 08 Nov 2012 15:10:41 GMT

I think that is the idea but I don’t always know the date column names. And will this work for a spreadsheet load of 3000 rows?

Steve

MayilVahanan — Thu, 08 Nov 2012 15:17:58 GMT

This will work.. Can u test n give your feedback?