Only need filename() and filetime() but ooxml XLSX files are huge and takes 30 seconds just to get this (FIRST 1 LOAD)
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);