filename does not change when loading from files with wildcard

[curiousfellow]

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

[Or · Accepted solution]

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;

[curiousfellow]

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

[Walker]

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