Discussion board where members can get started with Qlik Sense.
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;