Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Peter_Brunner
Creator
Creator

Populating data in a blank field Null Mapping ?

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Peter_Brunner
Creator
Creator
Author

Hy again Gysbert

I tried that one before as well but no go !

Peter

Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
Peter_Brunner
Creator
Creator
Author

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

?