Error Log In Qlikview

Prabhu1204 — Sat, 24 Oct 2020 06:09:11 GMT

Hi,

Is there a way to log all field not found error in same excel file, I am using a error script which logs one error and exclude the file and load other file.

The input file may have two or more field with different as it comes from each department, at last i have to consolidate all the files .

In one file, I need to know all the errors and load another file.. How to achieve this

Re: Error Log In Qlikview

marcus_sommer — Mon, 26 Oct 2020 12:45:10 GMT

It's not possible with ERRORMODE because it will always break by the first found error. This means you need to check the existing of fields with a regular method. For example by using a pre-load like:

t: first 1 load * from Excel;

and afterwards you creates a loop like:

for i = 1 to nooffields('t')
   let f = fieldname($(i), 't')
   ... // your match against the expected fields
   ... // log your measures and react in any way
next

- Marcus

topic Error Log In Qlikview in App Development

Error Log In Qlikview

Re: Error Log In Qlikview