topic Re: filename does not change when loading from files with wildcard in QlikView

filename does not change when loading from files with wildcard

curiousfellow — Wed, 24 Nov 2021 11:12:46 GMT

I have a script like this :

new_table:

Load

field1

field2

filename() as name_sourcefile

from c:\pathname\*.xml)

All records are loaded but name_sourcefile gets value "new_table" and not the name of the sourcefile.

Do I misunderunderstand the function filename() ?

Re: filename does not change when loading from files with wildcard

Or — Wed, 24 Nov 2021 11:27:38 GMT

I ran this (correcting the syntax first, of course) and the file names were loaded correctly, so I'm not sure what the issue is on your end...

new_table:

Load

filename() as name_sourcefile

from C:\myPath\*.xml;

Re: filename does not change when loading from files with wildcard

curiousfellow — Fri, 26 Nov 2021 08:28:07 GMT

I am sorry, was looking at fieldname retrieved from $(table)

Re: filename does not change when loading from files with wildcard

Walker — Tue, 30 Nov 2021 09:36:23 GMT

The day day part in the folder can be set, but we are not sure about the time part in the folder name, it depends on the time of creation of that folder. Tried to add this path for validation task in ADF but there I was not able to provide wildcard path for the time part, since we are not known what is exact value.

upsers portal