topic hide some script in log in QlikView

hide some script in log

priyarane — Mon, 20 Mar 2017 10:04:20 GMT

Hi Community,

Is there any way hide script in logs.

we are have set error mode=0 and set error mode=1, in between 0 and 1 we are using drop field statement at the end of script, we are finding field not found and which can be ignored that QV developers know but my production support team saying some error we found. so I need to hide that part.

Is there any way?

-Priya

Re: hide some script in log

sergio0592 — Mon, 20 Mar 2017 11:16:43 GMT

You can make hidden script. He is invisible in the reload log file.

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Hidden_Script.htm

Re: hide some script in log

flipside — Mon, 20 Mar 2017 11:32:23 GMT

You need to wrap a test around the DROP command ...

If NoOfRows('Test') >=0 then
Drop Table Test;
EndIf;

flipside

Re: hide some script in log

priyarane — Mon, 20 Mar 2017 12:28:58 GMT

this hidden script will come first but my script at last of script

Re: hide some script in log

priyarane — Mon, 20 Mar 2017 12:30:28 GMT

Hi Dave, can you pls elaborate pls.

Re: hide some script in log

flipside — Mon, 20 Mar 2017 13:13:24 GMT

Apologies, I put code up for testing a table rather than a field. In that case use this code ...

If FieldValueCount('Data')>=0 then
Drop Field Data;
EndIf;

This will test for the existence of the field before running the DROP command and generating the error message.

flipside

Re: hide some script in log

priyarane — Tue, 21 Mar 2017 07:30:07 GMT

Thanks Dave, it can work for one field, but I have fields more than 50 columns. Can you pls share your ideas if you have.

-Thank you

Re: hide some script in log

flipside — Tue, 21 Mar 2017 08:27:57 GMT

Yes, just wrap a loop around it, like this ...

For each field in 'Data','Data2','Data4'
If FieldValueCount('$(field)')>=0 then
Drop Field $(field);
EndIf;
Next field;

flipside

EDIT: You might find it easier to store the desired fields to drop in a list as in this example ...

FieldsToDrop: //Note: it is dropping itself in the list!
Load
chr(39) & concat(FieldToDrop,chr(39) & ',' & chr(39)) & chr(39) as FieldToDrop
inline [
FieldToDrop
Data
Data2
Data4
FieldToDrop
];

let vFieldsToDrop = peek('FieldToDrop');

For each field in $(vFieldsToDrop)
If FieldValueCount('$(field)')>=0 then
Drop Field $(field);
EndIf;
Next field;