Locate missing values automatically after recharging

[Anonymous]

Hello,

I have several qvw which are reloaded one after the other or in parallel and I try to highlight automatically the presence of the value ' Anomaly mapping ' generated during applymap.

I wish to make it most automatically possible, for example by scanning every qvw of a directory to find this value in the whole of the data. The objective is to locate quickly the anomaly to go back to the mapping in cause and update the data sources before reloading.

Is there an application to make it or a macro?

Beforehand thank you.

Christophe

[Clever_Anjos]

Pseudo code:

t:

mapping LOAD * FROM YourMap;

table:

LOAD

    applymap('t',afield,'**') as afield

    otherfields

from yourqvd(qvd);

temp:

LOAD count(afield) as q resident where afield = '*';

if noofrows('temp')> 0 then

    temperror:

   LOAD afield resident where afield = '*';

   store temperror into temperror.csv(txt);

endif