topic Re: List of all error files in QlikView

List of all error files

rahulsud007 — Sun, 11 Oct 2015 08:52:15 GMT

Dear all,

I want a list of all error files. Suppose in the script I have four load statement. In the First statement I have all the field name and the file. In the second load statement I have a field missing. In third and fourth load statement I have the file missing. I want to see all the errors.

I have used errormode=0; So that reload wont fail. But I want list of all errors. scripterrodetail shows only the last error in detail not the entire error.

Attaching my script and excel. Plz help

Re: List of all error files

petter — Sun, 11 Oct 2015 09:04:10 GMT

You have the special variable ScriptErrorList which is actually a list of all errors... isn't that sufficient for you needs?

If not you can always use an:

ErrorList: LOAD $(ScriptErrorDetail) AUTOGENERATE 1;

After each load to get a single table containing all ScriptErrorDetails for the entire load script. Possibly storing the results at the end of the load script into a QVD for later reference...

Re: List of all error files

rahulsud007 — Sun, 11 Oct 2015 09:20:58 GMT

Hi Peter, Thanks for your reply. The Error detail will give u only the detail error of the last error not the entire list as I shown in my application above.

Can you please help with an demo application where I can see multiple errors with their filename?

Re: List of all error files

petter — Sun, 11 Oct 2015 09:24:23 GMT

That is the purpose of using the LOAD .... AUTOGENERATE 1 after each load as it will by auto concatenation add multiple rows of ErrorDetails into this table called ErrorList. Give it a try...

Re: List of all error files

petter — Sun, 11 Oct 2015 09:37:48 GMT

This is tested and works with your attachements:

set ErrorMode=0;
ABC:
LOAD ID, 
     Name,
     Age
FROM
ABC.xlsx
(ooxml, embedded labels, table is Sheet1);


ERRORLIST: LOAD  1 AS LoadNo, '$(ScriptErrorDetails)' AS ErrorDetail AUTOGENERATE 1;


LOAD ID, 
     Name, 
     Age
FROM
PQR.xlsx
(ooxml, embedded labels, table is Sheet1);


ERRORLIST: LOAD  2 AS LoadNo, '$(ScriptErrorDetails)' AS ErrorDetail AUTOGENERATE 1;


LOAD ID, 
     Name, 
     Age
FROM
xyz.xlsx
(ooxml, embedded labels, table is Sheet1);


ERRORLIST: LOAD  3 AS LoadNo, '$(ScriptErrorDetails)' AS ErrorDetail AUTOGENERATE 1;


LOAD ID, 
     Name, 
     Age
FROM
rsk.xlsx
(ooxml, embedded labels, table is Sheet1);


ERRORLIST: LOAD  4 AS LoadNo, '$(ScriptErrorDetails)' AS ErrorDetail AUTOGENERATE 1;

You will end up with a table named ERRORLIST that contains four rows and ScriptErrorDetails for each load statement...

Re: List of all error files

rahulsud007 — Mon, 12 Oct 2015 06:57:56 GMT

That was great Peter extremely thankful of you.

Re: List of all error files

petter — Mon, 12 Oct 2015 07:04:14 GMT

My pleasure.