Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to load all filenames in temptable and use them for another script.
I have a very simple syntax
TEMP_FILE:
LOAD
FileBaseName() as "filename",
FileTime() as "Date_file"
FROM
There should be 57 records in the table.
But it shows only 3.
What am i doing wrong?
Thanks,
A.
Okay, try this code instead if you just want the file names (this will return hidden files also) ...
For each file in FileList('C:\Users\alwinsc\Documents\QlikView\ProdStat\*')
TEMP_FILE:
LOAD
subfield('$(file)','\',-1) as filename,
FileTime('$(file)') as Date_file autogenerate 1;
Next;
Your filename will have the extension, but if you don't need it just wrap around another subfield statement with '.' delimiter.
flipside
Hi,
From my side script runs correctley please check once from your end.
Reagrds,
Anand
No it does not work.
I get 2 filenames and i need some around 60.
Are the files set to hidden? These won't show.
flipside
No the folder and files are not hidden.
But when i create a new table i get some strange dimensions.
(please see attachment)
A.
Okay, try this code instead if you just want the file names (this will return hidden files also) ...
For each file in FileList('C:\Users\alwinsc\Documents\QlikView\ProdStat\*')
TEMP_FILE:
LOAD
subfield('$(file)','\',-1) as filename,
FileTime('$(file)') as Date_file autogenerate 1;
Next;
Your filename will have the extension, but if you don't need it just wrap around another subfield statement with '.' delimiter.
flipside