topic Help with FileBaseName() function in QlikView

Help with FileBaseName() function

riyazasma1009 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Help with FileBaseName() function

ajsjoshua — Mon, 20 Jun 2016 07:33:02 GMT

Hi,

Help with filebasename() | Qlik Community

Re: Help with FileBaseName() function

Anonymous — Mon, 20 Jun 2016 07:35:51 GMT

joshua solomon

Already shared, Go through it

Re: Help with FileBaseName() function

riyazasma1009 — Mon, 20 Jun 2016 09:59:21 GMT

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.

Re: Help with FileBaseName() function

ajsjoshua — Mon, 20 Jun 2016 10:16:30 GMT

Hi,

What type of files are ignored.

Re: Help with FileBaseName() function

riyazasma1009 — Mon, 20 Jun 2016 10:21:12 GMT

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

Re: Help with FileBaseName() function

marcus_sommer — Mon, 20 Jun 2016 10:32:49 GMT

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