Discussion board where members can learn more about Qlik Sense App Development and Usage.
Thank you all for the proper solution,
Like you said Marcus the best way is to solve it in beforehand.
But before this card is being closed with the solution.
Can you please explain me the approach to load the date from table name and which functions can be used for that?
FROM [lib://AttachedFiles/mar+apr.xlsx](ooxml, embedded labels, table is DE_201903);
There is no native functionality in Qlik else it needs to be done per SQL or VBA/VBS. Here a few examples:
Another approach but not easier would be to unzip the XLSX (also per EXECUTE statement) and then reading the various xml-files to find the included sheets.