Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Load and Unpivot a Spreadsheet Help

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

Tags (3)
3 Replies

Re: Load and Unpivot a Spreadsheet Help

HI

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

Not applicable

Re: Load and Unpivot a Spreadsheet Help

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

Re: Load and Unpivot a Spreadsheet Help

HI

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

Community Browser