Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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?
Hi,
your try with trace function
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);
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.
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?
I think this tool from Rob will be quite useful: Search Recipes | Qlikview Cookbook.
- Marcus
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 ....
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.