Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
ariel_klien
Valued Contributor

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

Re: Error Variables to Table

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
Honored Contributor

Re: Error Variables to Table

Community Browser