Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
i have tried to upload in xlsx files (about 6 or seven excel file) , but Qlikview shows file not found error message.
Please find the script below
Directory f:\Finance\monthly_summaries;
For each ExcelFile in filelist ('*.xlsx')
EOM_HISTORY:
Load * From $(ExcelFile) (ooxml, embedded labels, table is [EOM_SHEET$]);
Next ExcelFile;
hi Jagan
issue is resolved with the support of Evan Kurowski
please find below thread for further details
Hi,
Try like this
EOM_HISTORY:
Load *
From
[f:\Finance\monthly_summaries\*.xlsx] (ooxml, embedded labels, table is [EOM_SHEET$]);
Is F: drive is your local machine drive? If yes it will work otherwise if it is shared drive the you need to give the actual path like \\10.10.29.38\SomeFolder.
No need of Loop, hope it helps you.
Regards,
Jagan.
Hi
i following error
i get the above error message when i load them, what could be the reason
hi Jagan
issue is resolved with the support of Evan Kurowski
please find below thread for further details
Dear Jayanthan,
here is the problem "[EOM_SHEET$]", remove dollar sign [EOM_SHEET]. I hope this will help you.
Kind regards,
Ishfaque Ahmed
Dear Isfaque
True .I have changed and executed
Thank You
Best Regards
Jayanthan