Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
Does it possible to put the error variables into table?
In my script i'm connecting to 500 DB.
this is part of the loop:
but it doesn't work
if(ScriptError >0) then
ErrorTable:
LOAD '$(vDB_Name)' as ErrorTable_WhiteLabel,
'$(ScriptError)' as ErrorTable_ScriptError,
'$(ScriptErrorDetails)' as ErrorTable_ScriptErrorDetails
AutoGenerate (1);
END IF
But it didn't work
I am getting null values in ErrorTable_ScriptError, ErrorTable_ScriptErrorDetails
Any suggestions?
BR
Ariel
Maybe first assign them to a variable and then use the dollar sign expansion. You might find this link to be useful: Error handling in script
Best,
Sunny
Ariel,
Refer this thread https://community.qlik.com/message/566028#566028