Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
im going to start using weather data, and it comes in this format per month in the same file. Lets call it weather.xls.
I've made named fields inside the excel file:
January2016
February2016
March2016
April2016
May2016
June2016
....
What i want to do:
1. Read only the tablenames in the list above.
2. Cross table the day of the month (1-30/31).
3. End result cross table: get a vertical list of normal TAM, TAM, RR with the corresponding day of the month. (1,2,3,4,5,6,7).
Element | Normal TAM | TAM | RR |
1 | 12,4 | 13,4 | 1,5 |
2 | 12,5 | 16,9 | 2 |
3 | 12,6 | 20,4 | 0 |
4. Add for each filelist [lib://desktop/weather*.xls] including the specific table names and cross table function.
I've only done cross table with two rows before and i don't know how to use import a named list of table names from excel file.
Hope you can help me out on this one.
Thanks,
hope this helps you The Generic Load
Vikas