Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
HI
This will work.. Can u test n give your feedback?