Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
christophebrault
Specialist
Specialist

Avoid script stopping

Hi,

I have a for each expression working fine and loading tables. But for some tables, a field is missing. When i reload, the script is stopping on each table where this field miss.

How can i solve this problem and say :" If 'this field' is missing, don't load the table."

Thanks

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin
1 Solution

Accepted Solutions
Not applicable

Hi There,

You could set the errormode to 0.

By default QV sets the error mode to 1. When you set the error mode to 0 QV will ignore the error and continue loading the rest of your statements/tables as required.

Use this at the start of your script.

set errormode=0;

Cheers,

Shyam

View solution in original post

2 Replies
Not applicable

Hi There,

You could set the errormode to 0.

By default QV sets the error mode to 1. When you set the error mode to 0 QV will ignore the error and continue loading the rest of your statements/tables as required.

Use this at the start of your script.

set errormode=0;

Cheers,

Shyam

christophebrault
Specialist
Specialist
Author

Nice !

Works perfectly, thanks.

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin