Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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