Help with FileBaseName() function

[riyazasma1009]

Hi All,

I want to load just the base file names of all the files present in a folder. This folder contains different types of files such as qvw, txt, xls,xlsx, doc,docx, pdf, png etc.

I am aware that FileBaseName() returns the file name excluding the file path and file extension.

I am using the below script :

The problem is it is not giving the file base names for all the files. The base file names of files in xls, xlsx, png and some doc files are not being returned.

Can anyone please help me with the same?

Thanks,

Asma

[ajsjoshua]

Hi,

Help with filebasename() | Qlik Community

[Anonymous]

joshua solomon

Already shared, Go through it

[riyazasma1009]

Thanks Balraj and Joshua Solomon for the quick reply!!

But my doubt here is all the files present in the folder are not being read by the FileBasename() function. Some files are being ignored i.e. even though they are present in the folder, they are not being read.

[ajsjoshua]

Hi,

What type of files are ignored.

[riyazasma1009]

Some qvw files, all xls files, all png files. After each reload, the list of files being ignored by the FileBaseName() function changes.

[marcus_sommer]

It looked for me that you didn't want to list the filenames of files which you are loading within qlikview else you want list all files which are in certain folders, right? Then you need to use flielist like in example from the link above and not filebasename().

- Marcus