topic Re: How to Capture error details in QlikView

How to Capture error details

prasadreddy — Tue, 18 Feb 2014 10:04:35 GMT

Hello Experts,

Can any one help me on the below scenario plz asap..

I have 20 excel files to load the data, I have used 'ErrorMode = 0' to skip the files which is having wrong header name,

but in log file I can see that which file was not loaded and Error occurred while loading,

But I need to capture that error details, and se send the error details as alert mail to users, which describes that what ever the files were not loaded..

My script like below:

For each file in filelist ('C:\Data\*.xlsx')

ErrorMode = 0;

Tab1:

Load A1,

B1,

C1,

From

[$(File)] (ooxml, Embededlables, Header lines 2)

Next File;

Re: How to Capture error details

Gysbert_Wassenaar — Tue, 18 Feb 2014 11:30:38 GMT

You can use the ScriptError and ScriptErrorDetails variables. See this document: ErrorHandling in Qlikview

Re: How to Capture error details

Tue, 18 Feb 2014 12:36:27 GMT

Hi ,

Capture your error through script error variables and PFA

Re: Alert Mail On Post Reload