topic Re: Error Variables to Table in QlikView

Error Variables to Table

ariel_klien — Wed, 27 May 2015 13:53:35 GMT

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?

Ariel

Re: Error Variables to Table

sunny_talwar — Wed, 27 May 2015 14:04:12 GMT

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

Re: Error Variables to Table

Siva_Sankar — Fri, 29 May 2015 02:50:40 GMT

Ariel,

Refer this thread https://community.qlik.com/message/566028#566028