Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
curiousfellow
Creator III
Creator III

filename does not change when loading from files with wildcard

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() ?

Labels (1)
1 Solution

Accepted Solutions
Or
Master II
Master II

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;

Or_0-1637753241791.png

 

View solution in original post

3 Replies
Or
Master II
Master II

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;

Or_0-1637753241791.png

 

View solution in original post

curiousfellow
Creator III
Creator III
Author

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

Walker
Contributor
Contributor

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