topic Re: Suppress Script Execution Progress writeouts in QlikView

Suppress Script Execution Progress writeouts

mbrdenmark — Tue, 05 Dec 2017 10:00:32 GMT

Hello,

I have a Qlik document which loops through a large number (1000+) raw excel and csv files and it generates a very large logfile with 1000+ lines with:

Table << Excel1 663 lines fetched

Table << Excel2 534 lines fetched

Table << Excel3 789 lines fetched

...

I would like to manually control what is printed in the logfile by temporary disable execution log messages, and enabled it after the file loading loop is finished.

So does QlikView have anything like "@echo off/on" in load scripts?

Re: Suppress Script Execution Progress writeouts

devarasu07 — Tue, 05 Dec 2017 10:39:00 GMT

Hi,

your try with trace function

Trace ‒ QlikView

sample,you can try like below,

Main:
load * inline
[
ID,Amount
1,200
2,100
3,150
];
Let MyMessage = NoOfRows('Main') & ' rows in Main Table';
trace $(MyMessage);

Re: Suppress Script Execution Progress writeouts

mbrdenmark — Tue, 05 Dec 2017 10:45:22 GMT

Thank you for the answer Devarasu R.

Currently I am looking for a way to temporary suppress the auto generated "Table << Data 20324 Lines Fetched" messages. If I could do so, I could use TRACE to write summary messages instead.

Re: Suppress Script Execution Progress writeouts

Colin-Albert — Tue, 05 Dec 2017 10:53:10 GMT

You can add extra logging by using Trace commands, but apart from disabling the document log completely, which I would not recommend, I do not know of a way of pausing and restarting the logging within a script.

Do you actually need to loop through all 1000+ files each time you reload the data?

Have you looked at using a incremental load, so you just append new files to your data?

Re: Suppress Script Execution Progress writeouts

marcus_sommer — Tue, 05 Dec 2017 13:39:33 GMT

I think this tool from Rob will be quite useful: Search Recipes | Qlikview Cookbook.

- Marcus

Re: Suppress Script Execution Progress writeouts

avinashelite — Tue, 05 Dec 2017 13:57:43 GMT

One alternative way is to place your script inside > hidden script > so nothing will get logged ...but you need have the herald of remembering the hidden script password ....

Re: Suppress Script Execution Progress writeouts

mbrdenmark — Wed, 06 Dec 2017 07:28:14 GMT

Thank you for the answer Colin.

I guess I just have to consider the solution, where I consolidate the data in an separate Qlik into one QVD and have it keep track of which files it already processed.

But it would be a nice feature to could disable the autogenerated log entries to complement a more manual approach with TRACE.