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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ariel_klien
Specialist
Specialist

Error Variables to Table

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

2 Replies
sunny_talwar

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

Siva_Sankar
Master II
Master II