Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is part of a more complex script but I've isolated/simplified the problem part of code - see below.
There are 4x matching files in the directory matching the * wildcard format. It takes almost 3 minutes to load this tiny bit of script - over 30 seconds per file.
The problem is there are almost 400 columns in these files (XLSX / ooxml). But I don't care about the columns or file content at this point, I just want the filename/filetime (in my bigger script I'm only loading data from those with filetime>=lastreload, so this initial step is just to get a list of new files).
Is there any way Qlik can produce a file directory (including filetime) without trying to interpret the file contents, which is what seems to take ages?
Thanks in advance.
Test:
FIRST 1 LOAD FileBaseName() as filename,
FileTime() as filetime
FROM
[\\server\share\folder\namingconvention_*.xlsx]
(ooxml);
filetime, filename, dir, dirlist, filelist, directory, biff, incremental
You can use the "For Each... filelist()" script to get file information without opening the files. See
-Rob
Edit: I think I mean OOXML not BIFF (XLSX)
You can use the "For Each... filelist()" script to get file information without opening the files. See
-Rob
Excellent, so much quicker! Thank you Rob.