Discussion board where members can get started with Qlik Sense.
I need to load all data in multiple excel sheet without mentioning the sheet name in the script.
anyone please guide me t complete this task.
i have attached the sample data.
Go to Solution.
Here we go
please refer to this:
Load Multiple excel sheets using For loop
Thanks for your valuable reply.
Can you please load the sample file which i have attached using your query.
First of all, disable the standard Mode so u can enter full path :
in desktop :
Editing an engine ‒ Qlik Sense
then load one sheet of ur excel file (so we can copy the (biff, embedded labels, table is [1$]); for a later use)
and then comment it:
// FROM [lib://data/Data.xls]
// (biff, embedded labels, table is [1$]);
now use this : change the path to ur excel file (u can directly enter Data.xls instead of *.xls)
FOR EACH file in FileList('C:\Users\OmarBenSalem\Desktop\Data\*.xls');
ODBC CONNECT32 TO [Excel Files;DBQ=$(file)];
FOR i = 0 to NoOfRows('tables')-1
LET sheetName = purgeChar(purgeChar(peek('TABLE_NAME', i, 'tables'), chr(39)), chr(36));
(biff, embedded labels, table is [$(sheetName)$]);
can you please share the above qvf file?
jayaseelan have my intervention helped you?