Read all file names from folder

[markgraham123]

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);

[m_woolf · Accepted solution]

see the attachment:

[vishsaggi]

Trythis?

LET vFolder = '\\files\' ;

Sample:

LOAD FileBaseName() AS TestName

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

[markgraham123]

This loads all data in the files too Vish.

[markgraham123]

This is awesome

Thanks a lot!!

[paulsparrow]

Any idea how to do this in Qlik Sense?