Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
I have 3 excel files in one folder with same column names, i want to load all sheets data from all excel files.
Here i don't want to connect any data base for excel files and my sheet names are Dynamic.
Here i am attaching my excel files.
Regards
Mahesh
Hi,
have you tried this for loop method
https://community.qlik.com/docs/DOC-4452
I tried that,i am not able to achieve that. if its possible prepare a sample app with my attached data.
-Mahesh
You will need to loop over the files using the above selections and in each, loop over the sheets using the solution here Need Help with loading multiple sheets of an Excel file
try like below,
Just define your excel file pathand QVD path.
Hi All,
Sorry for delay.
My Machine doesn't have Qv right now, if its possible can any one share script along with my all files data in table box.
-Mahesh
Hi Kush bro,
I defined my excel and qvd path, then i go for reload its showing below error
Here i am sending my files with qv app.please check and let me know where i am wrong.
Regards,
Mahesh