Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

bumin
Contributor II

check filename in an expression

I would like to check is a filename exists in a directory

depending on it I want to show the filename in a diagram

within the script I have found all JPG-Files

LET sDir = 'C:\Users\bumin\pictures\'; // Directory to look through

LET sFile = '*.JPG'; // Searchpattern

LET sSearchPattern = sDir & sFile;

// =================== Scan through directory and list all possible files

FOR EACH vFile in FileList (sSearchPattern)

FilesFound:

LOAD

'$(vFile)' AS FileFound

AUTOGENERATE 1;

NEXT vFile

now I want to check if a spcific filename does exists in FileFound

I have tried several functions but I didn' got it.

can someone help?

thanks

Bumin

1 Reply
bumin
Contributor II

check filename in an expression

I have enterred the followinh fomula:

=Match(sDir&docnum&'.JPG',FileFound)

but then I get each record twice

Bumin

Community Browser