Column header name changes every week - Can I automate load?

[#1]

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

[simondachstr]

Have a look at the Crossfield () functionality.