Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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)
itemweek 15week 16week17
file.xls (this week)
itemweek 16week 17week18

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

1 Reply
simondachstr
Luminary Alumni
Luminary Alumni

Have a look at the Crossfield () functionality.