Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
So i have an excel file with table in each sheet, each month we create a sheet with the month name and we use the same table layout to introduct data for that month, so i have January, February, Marsh data, i want to concatenate the tables in all the sheets dynamically into one because each month we add a new sheet so it must be dynamic
Any ideas?
January
February
Marsh
FullTable:
LOAD *
From [lib://path/*.xlsx]
(ooxml, embedded labels, table is [Table 1]);
or use below link
https://community.qlik.com/t5/Member-Articles/Dynamically-Loading-Multiple-Excel-Files/ta-p/1479021
In addition to the link from @anat if the sheet-names are known or could be derived in some way - like the available months in regard to today() - you wouldn't mandatory need an odbc-load to fetch the available sheets, for example:
t: load rowno() as MonthNum autogenerate 1 while iterno() <= month(today());
for each sheet in fieldvaluelist('MonthNum')
t: load * from Excel (ooxml, embedded labels, table is [$(sheet)]);
next