Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Is there a way to import the excel data dynamically from all the tabs?
Each tab may/may not have the same data structure.
Is there a way qlikview identifies each tab as the separate table and creates the tables dynamically.
Kindly help.
Thanks & Regards
Jeba
try
with an odbc connection and a loop
Follow this documents
Hi Anand,
It seems its almost worked
Could you please help me with the below error.
Bad Zip File
[Sheet3]:
LOAD *
FROM
(ooxml, embedded labels, table is [Sheet3])
Thanks & Regards
Jeba
You can do this using an ODBC connection to excel. but the sheets must be the same structure
Regards
Alan
(ooxml, embedded labels, table is [Sheet3])
I think ooxml is for xlsx files. Can you please make sure if you have the correct format file.
you can also use filename() as FileName in your load script to identify which files have been loaded.
Put * before .xls
Bad Zip File
[Sheet3]:
LOAD *
FROM
(ooxml, embedded labels, table is [Sheet3]) \\ Check this line by loading a excel file and then use it
I believe you have to use for loop