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: 
markgraham123
Specialist
Specialist

Read all file names from folder

Hi all,

i'm trying to load only file names from the folder but not the data in it.

When i try the below code, it is fetching data too..which is  a performance issue.

Can someone please help?

Any help is highly appreciated!

SET vFolder = '\\files'; //Storing the folder path in a variable.

Files:

LOAD

FileName() as Test

FROM $(vFolder)\*.qvd (qvd);

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

see the attachment:

View solution in original post

5 Replies
m_woolf
Master II
Master II

see the attachment:

vishsaggi
Champion III
Champion III

Trythis?

LET vFolder = '\\files\' ;

Sample:

LOAD FileBaseName() AS TestName

FROM $(vFolder)*.qvd(qvd);

markgraham123
Specialist
Specialist
Author

This loads all data in the files too Vish.

markgraham123
Specialist
Specialist
Author

This is awesome

Thanks a lot!!

paulsparrow
Contributor III
Contributor III

Any idea how to do this in Qlik Sense?