Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shivam0703
Contributor III
Contributor III

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

 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

4 Replies
m_woolf
Master II
Master II

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

 

shivam0703
Contributor III
Contributor III
Author

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

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Brett_Bleess
Former Employee
Former Employee

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

 

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.