Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

how to use relative path in (for each FoundFile in filelist())

Hi ,

     I am  hard codeing the path like  filelist(E:\QlikView) its working fine but when i am useing the relative path its not working. Its skiping the for loop code and going to end.

1 Reply
oscar_ortiz
Valued Contributor

Re: how to use relative path in (for each FoundFile in filelist())

You can try something like this:

vImagePath = '..\Images\';

FOR Each FoundFile in filelist ('$(vImagePath)' & '*.PNG')

Temp:
LOAD
'$(FoundFile)'
as Name,
FileSize( '$(FoundFile)' ) as Size,
FileTime( '$(FoundFile)' ) as FileTime
autogenerate 1;

NEXT FoundFile

Community Browser