topic Re: Populating data in a blank field Null Mapping ? in QlikView

Populating data in a blank field Null Mapping ?

Peter_Brunner — Tue, 30 Oct 2012 10:33:53 GMT

Hi Guys,

I have been testing different ways to solve this problem with eratic results

I need to map the blank PG field with PX. I tried a wildcard *REV* and no go

I now have a test model setup with mapping but there might be a better way of doing this

see my Test Qvw attched.

data:

load * inline [
ITEM, PG, Value
123123,AS, 2300,
620023,BC, 5000,
1-REV-I, ,9000,
2-REV-I, ,9001
3-REV-I, ,9002
4-REV-I, ,8200,
5-REV-I, ,7000,
6-REV-I, ,760,
7-REV-I, ,8800,
8-REV-I, ,800,
9-REV-I, ,3210,
];

MAP_NewCode:
mapping load * inline [
ITEM, PG,
1-REV-I,PX
2-REV-I,PX
3-REV-I,PX
4-REV-I,PX
5-REV-I,PX
6-REV-I,PX
7-REV-I,PX
8-REV-I,PX
9-REV-I,PX
];

data2:
load
ITEM,
if (PG=' ', ApplyMap('MAP_NewCode', ITEM, PG)) as PGs,
Value
Resident data;
drop Table data;

any help would be appreciated

Peter

Re: Populating data in a blank field Null Mapping ?

Gysbert_Wassenaar — Tue, 30 Oct 2012 10:38:49 GMT

try: if (isnull(PG), ApplyMap('MAP_NewCode', ITEM, PG)) as PGs

Re: Populating data in a blank field Null Mapping ?

Peter_Brunner — Tue, 30 Oct 2012 10:44:47 GMT

Hy again Gysbert

I tried that one before as well but no go !

Peter

Re: Populating data in a blank field Null Mapping ?

Gysbert_Wassenaar — Tue, 30 Oct 2012 10:55:59 GMT

Oh well, then we do it like this: if (len(PG)=0, ApplyMap('MAP_NewCode', ITEM, PG),PG) as PGs,

Inline doesn't seem to create real nulls, but empty strings.

Re: Populating data in a blank field Null Mapping ?

Peter_Brunner — Tue, 30 Oct 2012 11:09:27 GMT

Yes that worked! Thanks, but now you have an intersting point, in the actual qvw I need to apply this

I have real Nulls so I should use your orignal code

if (isnull(PG), ApplyMap('MAP_NewCode', ITEM, PG)) as PGs