Discussion board where members can get started with QlikView.
I want to load all filenames in temptable and use them for another script.
I have a very simple syntax
FileBaseName() as "filename",
FileTime() as "Date_file"
There should be 57 records in the table.
But it shows only 3.
What am i doing wrong?
Go to Solution.
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\*')
subfield('$(file)','\',-1) as filename,
FileTime('$(file)') as Date_file autogenerate 1;
Your filename will have the extension, but if you don't need it just wrap around another subfield statement with '.' delimiter.
From my side script runs correctley please check once from your end.
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.
No the folder and files are not hidden.
But when i create a new table i get some strange dimensions.
(please see attachment)