Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi..can anyone explain the syntax of error mode.
i have created like this,
set ErrorMode=0;
load * from A;
if ScriptError>1 then
Load next;
end if
actually my requirement is,if the table A is error means it should skip dt one and go to next script automatically.
The syntax looks good. What exactly is your issue?
Hi Sindhu,
Please find following syntax from qlikHelp page
ErrorMode
Arguments:
Argument | Description |
---|---|
ErrorMode=1 | The default setting. The script execution will halt and the user will be prompted for action (non-batch mode). |
ErrorMode =0 | QlikView will simply ignore the failure and continue script execution at the next script statement. |
ErrorMode =2 | QlikView will trigger an "Execution of script failed..." error message immediately on failure, without prompting the user for action beforehand. |
Example:
set ErrorMode=0;
Thanks,
Pooja
Dear Sindhu,
Your script looks fine. Please have a look into given below I hope you are looking for that on
set ErrorMode=0;
load * from A;
if ScriptError = 1 then
load * from B;
elseif ScriptError = 2 then
load * from C;
else
exit script;
end if
Kind regards,
Ishfaque Ahmed
Hi,
Try like this
set ErrorMode=0;
load * from A;
if ScriptError <> 0 then
Load next;
end if
Hope it helps you.
Regards,
jagan.
or try
set ErrorMode=0;
load * from A;
if ScriptErrorCount >1 then
Load next;
end if
Regards,
Jagan.