Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
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;
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;