Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Load automatically new column from Excel

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 ?

cocobello3_0-1593525128434.png

Thank you very much for the help !

 

 

Labels (1)
1 Reply
Highlighted

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