Yeah, just use the code I provided above but instead of loading just the First 1 do a Load * of the files. To give more specific advice I would have to see your raw data and script but if all the files are the same you can load them using a Loop. If they are difference then us the If command above to load each file in turn only if it exists and use the Loop to create a log file with a list of the file names.
p.s. Don't forget to "Like" my comments if they've been helpful.
The code is now finally working fine - I cannot check the exact figures, but it looks ok - just the same as the old "Wildcard-LOAD".
The remaining issue is, when I fill in the original directory where those lists usually are (into that FileList, I will post it), then nothing happens - the code is just not executed, the log continues straight away with the next table in line.
Yesterday I copied those lists to a directory on the QlikView_server that I can access - there it works fine and all the information is in the log.
(the access, though, is not an issue since the reloading is being done by a "QlikView_user" who does have access to the original directory.
The original code (which used to work, but gave me no detailed debugging information) looked like this:
[list_of_fields] FROM [\\rgb1sfs201\Regensburg\MPL\05-Liefertreue_PR_Listen\F2_*für*.xlsx] (ooxml, embeddedlabels);
The new code (which works, but not out of that directory) looks like this:
If I understand that correctly, that >directory< command tells QlikView in which directory to look for that FileList in the following LOAD_statement.
I'll try this.
P.S.: One thing is not quite clear to me, though: The order - does that >directory< command have to go before or after the >For each ...< command? You seem to have that >For each ...< twice, with the >directory< inbetween, that confuses me ...
P.P.S.: And one more thing: Can I somehow reset that >directory< command? Apparently, there were some relative paths in the tables loaded afterwards, and they got mixed up with that and broke. I'm replacing them with absolute paths now. Still ...
now this is solved at long last. In the meantime, we had a complete Crash - nothing loaded anymore, the automated reload_schedule went on strike and I couldn't start anything manually in QMC, either - then my boss restarted the QDS_service and all was well again ;-) We had that a few times before, but twice today - that should just not happen.