Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I wanted to know that how to load multiple excel files with different sheet name in Qlik sense
You would probably get more responses with more information.
Hi jonathan,
1)File names are in same folder(Ex: Expense(folder),expense_Apr2017,expense_May2016(Excel filename))
2)for Excel expense_May2016 sheetname are A,B,C,D
for Excel expense_Apr2017 sheetname are A,B,C,E,F
(Excel Sheetnames are not known..it should load dynamically)
3)All the sheets contain same information
It may help you but change the code according to your requirements.
Hi,
Have you tried something like this??
Load ...
from
FROM [folder/expense_*.xlsx]
(ooxml, embedded labels);
Hi,
Ya i tried this..I list the available sheetnames in excel & used for loop to get all sheet names ..but while loading the excel file Excel expense_May2016 i get error msg like Sheet name E & F not found..similarly while loading the excel file Excel expense_Apr2017 i get error msg like Sheet name D not found..Is there any other to solve this issue
I also tried using ODBC Connectivity to get the sheetnames dynamically like Qlikview..but while using ODBC connect 32 to [...] i got error message like u cant connect to ODBC..u can only use lib file
In Qlik Sense, you have to create a new connection for ODBC, and specify path for folder.
Go to Create New Connection and ODBC connector and specify path
Hi aparna,
i created ODBC connection ...after that i insert the connection string into the application..
but i cannot use ODBC connect 32 to [..] in qliksense like Qlikview