Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Users, make your voice heard! Participate in Wisdom of Crowds® Market Study: Start Survey
cancel
Showing results for 
Search instead for 
Did you mean: 
S_Hoebee
Contributor
Contributor

Track progress in logfile while loading excel files for QVD

Hi,

While making QVD files, I load from a lot of different excel files using a wildcard. 

So for example files KPI_DATA_19WK01, KPI_DATA_19WK02, KPI_DATA_19WK03 , etc.

I would like to input a trace or other way of seeing which document it is loading at the moment.

Any suggetsions on how to solve this?

Attached an example screenshot, where i can't see if i'm half way or nearly finished with loading the excel files.

2 Replies
mahaveerbiraj
Creator II
Creator II

Hi ,

 

I hope trace keyword will help you , please go through below URL.

https://help.qlik.com/en-US/sense/September2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptReg...

Regards

Mahaveer   

S_Hoebee
Contributor
Contributor

Hi,

Thanks for your reply.

The script loads all the tables using a wildcard and concatenates them into 1 table.

As far as I can see I'm not allowed to use Trace within the script part from load to from; So using a trace I will only get a message after it has loaded & concatenated all 52 separate files.

regards Sam

example:

BaseData:

LOAD

*

FROM [lib://E new (samsung-els_s.hoebee)/EOC/WEDC/RawData/SEBNRAW20*.xlsx]

 (ooxml, embedded labels, table is Sheet1);

Trace ----------Will it work-----------

only gives me the trace after all is loaded and concatenated, while i would want a message after each excel is done.