topic Re: ScriptErrorDetails not fetching multiple error details in QlikView

ScriptErrorDetails not fetching multiple error details

Thu, 22 May 2014 14:38:40 GMT

Hi,

I need help in using ScriptErrorDetails.

I am using below code to fetch data from multiple excel files:

---------------------------------
Read_Files:

LOAD
*

FROM
Z:\files\*my_file*.xlsx
(ooxml, embedded labels, table is Open);

ErrorDetails:
Load
'$(ScriptErrorDetails)' as vScriptErrorDetail
AutoGenerate(1);

------------------------------------

After running this, i get following value in vScriptErrorDetail :

Field not found - <Emp-Id>

However there were 2 fields that were missing in different files:

Emp-Name column was missing in one and Emp-Id column in another.

But vScriptErrorDetail is storing only error in file read last.

I want vScriptErrorDetail to give following result:

Field not found - <Emp-Name>

Field not found - <Emp-Id>

Thanks.

Re: ScriptErrorDetails not fetching multiple error details

maxgro — Thu, 22 May 2014 15:11:00 GMT

I don't see any field

Emp-Id

in your script or I'm missing something?

I suppose Qlikview check (or store) only first error of a single statement.

So you get only the first wrong field in error variable (Emp-Id); change the order of the fields and you'll get Emp-Name

The same if you set ErrorMode to 1; the pop-up only show the first error by statement.

Re: ScriptErrorDetails not fetching multiple error details

Thu, 22 May 2014 21:09:18 GMT

Thanks, but if you see the code..its loading all the fields from file"*my_files*.xls" in which column emp_id and emp_name is there. I want both the field causing the error in my output text file.

My purpose is to show my users that we have 2 field error in the reload and these are the fields causing the error. Hope I am making it clear for you to help.