Discussion Board for collaboration on QlikView Scripting.
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.
load * inline [ITEM, PG, Value123123,AS, 2300,620023,BC, 5000,1-REV-I, ,9000,2-REV-I, ,90013-REV-I, ,90024-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,PX2-REV-I,PX3-REV-I,PX4-REV-I,PX5-REV-I,PX6-REV-I,PX7-REV-I,PX8-REV-I,PX9-REV-I,PX ];data2:loadITEM, if (PG=' ', ApplyMap('MAP_NewCode', ITEM, PG)) as PGs, Value Resident data; drop Table data;
any help would be appreciated
Go to Solution.
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.
try: if (isnull(PG), ApplyMap('MAP_NewCode', ITEM, PG)) as PGs
Hy again Gysbert
I tried that one before as well but no go !
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