Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Load automatically new column from Excel


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 !



Labels (1)
1 Reply

Re: Load automatically new column from Excel

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:
FROM YourFile.xlsx;