Qlikview: How to log Filename with Wildcards

[flintrop]

Hi everybody,

after spending 2hours to solve a problem, I'd like to know if there is a more comfortable solution.

Do you know a solution?

I've got this scipt

Load 
	filename() as SourceZeitnachweis_StrukturVor2017,
	*
FROM
[$(varSource)Daten-Zeiterfassung\BestNr*.xlsx]
(ooxml, embedded labels);

STORE Zeitnachweis_Struktur2017 INTO ..\300-QVD\Zeitnachweis_Struktur2017.qvd (qvd);

DROP Table Zeitnachweis_Struktur2017;

​In the Log of this document I only see the filename with Wildcard for each sourcefile.

How can I change the Skript to get the complete filepath in the Log?

I tried to use Trace, put can't find a solution to get the path.

I like to find the file who has the wrong permission, so that a load did not run.

In real life I found the file while trying to copy it to a test-Location.

Thanks in advance.

Benjamin

[Claudiu_Anghelescu]

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptRegularS...

[flintrop]

And how can I get the path of the file.

Like I said "I tried Trace".

[marcus_sommer · Accepted solution]

I suggest to use a filelist-loop instead of a wildcard-load - here an example: Load-a-sequence-of-qvd-files. The log should show all filenames and you could also TRACE the file-variable and furthermore apply various checks and/or ERRORMODE to skip unwanted files.

- Marcus

[flintrop]

Great solution. Thank you.