Error Log In Qlikview

[Prabhu1204]

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

[marcus_sommer · Accepted solution]

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