topic Re: HOW TO GET MULTIPLE EXCEL FILENAMES (FROM SAME PATH) AS A FIELD IN QLIKVIEW USING LOOP in QlikView

HOW TO GET MULTIPLE EXCEL FILENAMES (FROM SAME PATH) AS A FIELD IN QLIKVIEW USING LOOP

shivam0703 — Sat, 16 Nov 2024 19:01:47 GMT

LET ME KNOW HOW TO GET EXCEL FILENAMES AS A FIELD IN QLIKVIEW USING LOOP SO THAT AT ONE GO I CAN FETCH ALL THE FILE NAMES IN QLIKVIEW EASILY.

THANKS

Re: HOW TO GET MULTIPLE EXCEL FILENAMES (FROM SAME PATH) AS A FIELD IN QLIKVIEW USING LOOP

m_woolf — Thu, 27 Feb 2020 12:57:02 GMT

load
FileName() as Filename
from YourPath\*.xlsx;

Re: HOW TO GET MULTIPLE EXCEL FILENAMES (FROM SAME PATH) AS A FIELD IN QLIKVIEW USING LOOP

shivam0703 — Thu, 27 Feb 2020 13:18:10 GMT

In Qlikview only variable field is created value is missing in that.

Re: HOW TO GET MULTIPLE EXCEL FILENAMES (FROM SAME PATH) AS A FIELD IN QLIKVIEW USING LOOP

rwunderlich — Fri, 28 Feb 2020 15:48:33 GMT

To get only one row per filename, I think you want to add "First 1"

First 1 load
FileName() as Filename
from YourPath\*.xlsx;

-Rob

Re: HOW TO GET MULTIPLE EXCEL FILENAMES (FROM SAME PATH) AS A FIELD IN QLIKVIEW USING LOOP

Brett_Bleess — Wed, 01 Apr 2020 13:58:42 GMT

If Rob's post was what you needed, please be sure to return to your thread and close it out by using the Accept as Solution button on his post. This also gives the posters credit for the help and lets other Members know the solution worked for you.

The only other thing I can add that might be of some further use is the following Design Blog post:

https://community.qlik.com/t5/Qlik-Design-Blog/Loops-in-the-Script/ba-p/1473543

Regards,
Brett