topic Locate missing values automatically after recharging in QlikView

Locate missing values automatically after recharging

Anonymous — Tue, 01 Dec 2015 16:14:54 GMT

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

Re: Locate missing values automatically after recharging

Clever_Anjos — Tue, 01 Dec 2015 18:21:39 GMT

Pseudo code:

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