Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
flintrop
New Contributor

Qlikview: How to log Filename with Wildcards

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.

20190819-ScreenshotLOG.PNG

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

Labels (3)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Qlikview: How to log Filename with Wildcards

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

4 Replies
Claudiu_Anghelescu
Contributor III

Re: Qlikview: How to log Filename with Wildcards

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

To help community find solutions, please don't forget to mark as correct.
flintrop
New Contributor

Re: Qlikview: How to log Filename with Wildcards

And how can I get the path of the file.

Like I said "I tried Trace".

MVP & Luminary
MVP & Luminary

Re: Qlikview: How to log Filename with Wildcards

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
New Contributor

Re: Qlikview: How to log Filename with Wildcards

Great solution. Thank you.