Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get a File Name of a file from a particular Folder?

Hi...

I am having a single csv file in a particular Folder.

I want to get the name of this file in my application.

Nw we are using

first 1

Load

filename()

as Name

frm.....

Its wrking fine.

Any other way exists?

3 Replies
Not applicable
Author

hi,

probably the following code shud work

set Root="C:\\mypath";

FOR each File in filelist(Root& '\*.*')

LOAD

filebasename() as nameofthefile

FROM $(File) ;

NEXT File



thanks

Not applicable
Author

Hi..

This is similar to the previous one...Thnks...

Shall we get into a variable instead of loading it...

Not applicable
Author

hi,

i don't think it is possible to get the filenames without loading it.

if there exists a way,then i am also curious to know about it.

we can wait for the reply from the big guns in qlikcommunity.

thanks