Load automatically new column from Excel

[cocobello3]

Hi,

Every week I get the sales per country in Excel under a new column. I ve connected the excel sheet to my Qlik Sense database. Is it possible to load automatically the new column in the script ?

Thank you very much for the help !

[Nicole-Smith · Accepted solution]

Instead of listing the fields in your load, you can use * to load all of the columns.

So instead of this:
LOAD Country, [08.juin], [15.juin], [22.juin]
FROM YourFile.xlsx;

It would look like this:
LOAD *
FROM YourFile.xlsx;