Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
load
FileName() as Filename
from YourPath\*.xlsx;
In Qlikview only variable field is created value is missing in that.
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
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