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.
mapping LOAD * FROM YourMap;
applymap('t',afield,'**') as afield
LOAD count(afield) as q resident where afield = '*';
if noofrows('temp')> 0 then
LOAD afield resident where afield = '*';
store temperror into temperror.csv(txt);