Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear QV community.
I would be grateful if someone could help me with the following issue.
I weekly receive and analyze forecast.
The structure is basically as follows.
file.xls (past week) | |||
item | week 15 | week 16 | week17 |
file.xls (this week) | |||
item | week 16 | week 17 | week18 |
The situation is that each week the week number changes (it is increased in one).
I can edit the script, in order to adapt the app to this change, but I’d prefer to do this automatically.
Is there any way to “name” the fields during Load? Structure is the same, the only change is the column header name.
Thank you in advance for your help.
Leonardo
Have a look at the Crossfield () functionality.