Load and Unpivot a Spreadsheet Help

[#1]

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]

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

[#3]

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]

HI

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