topic Re: FileName(),FileDir() and FIleExtension() functions not working in my QVW. in QlikView

FileName(),FileDir() and FIleExtension() functions not working in my QVW.

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

Hello there

I'm trying a subroutine to enlist all files in a directory based on a couple of extensions. My load script is pretty simple (took it from Qlik help):

sub DoDir (Path)

For Each Ext in 'qvw', 'qvo', 'qvs', 'qvt', 'qvd', 'qvc'

For Each File in filelist (Path&'\*.' &Ext)

LOAD

'$(File)' as Name,

FileSize( '$(File)' ) as Size,

FileTime( '$(File)' ) as FileTime,

FileDir( '$(File)' ) as Directory,

FileName( '$(File)' ) as FileNm,

FileExtension( '$(File)' ) as Extension

autogenerate 1;

Next File

Next Ext

For Each Dir in dirlist (Path&'\*' )

Call DoDir (Dir)

Next Dir

End Sub

Call DoDir ('D:\#1Benazir\Qlik')

I get the following table

Why are three of the functions not returning any values?

Rgds,

Benazir

Re: FileName(),FileDir() and FIleExtension() functions not working in my QVW.

micheledenardi — Fri, 04 May 2018 08:10:27 GMT

You cannot use FileName(), FileDir() and FileExtension() with autogenerate because these functions supports only folder data connection in standard mode.

Re: FileName(),FileDir() and FIleExtension() functions not working in my QVW.

jonathandienst — Fri, 04 May 2018 08:12:57 GMT

Only FileTime() accepts an optional filepath. The other functions do not take a filepath, they are applied to the file being loaded in a load statement. Replace your load with something like this

First 1 LOAD

'$(File)' as Name,

FileTime() as FileTime,

FileSize() as Size,

FileDir() as Directory,

FileName() as FileNm

FileExtension() as Extension

FROM [$(File)] (.....)

Re: FileName(),FileDir() and FIleExtension() functions not working in my QVW.

Anonymous — Fri, 04 May 2018 08:33:09 GMT

Thank you so much Michele and Jonathan!

Re: FileName(),FileDir() and FIleExtension() functions not working in my QVW.

Anonymous — Fri, 04 May 2018 10:09:43 GMT

What do you mean by standard mode?

Re: FileName(),FileDir() and FIleExtension() functions not working in my QVW.

micheledenardi — Fri, 04 May 2018 11:42:42 GMT

It means to use DataConnection in the script and not relative or absolute path.

Refer to the below link for details:

https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/LoadData/file-system-access-restriction.htm