topic Handle mapping with nulls in QlikView

Handle mapping with nulls

pgalvezt — Wed, 12 Oct 2016 14:30:23 GMT

Hello,

I have a resident table with 2 conditions: a and b. I would like to bring F3 and F4 through Mapping. When cod is null

Bring F3 and F4 by Name... If cod is not null bring F3 and F4 by cod. The idea is always bring F3 and F4 by cod or

Name depending is the cod has data or use the Name when the cod be null. Sometimes b has the same cod one of them has data and the other line has F3 and F4 with null values. so I need to bring the line with data.

F1 Cod Name F3 F4

a 1 cod1 ab tg

b 2 cod2 bc rf

a cod3 ab ed

b 4 cod4 Here there isn't data in F3 and F4

b 4 cod4 tb yh so I need to bring this line.

Thanks!

Re: Handle mapping with nulls

jonathandienst — Wed, 12 Oct 2016 14:36:51 GMT

Where did tb and yh come from? I suggest that your provide more information such as the relevant mappings and the load script that applies the mapping as well as a more comprehensive set of examples.

Re: Handle mapping with nulls

rupamjyotidas — Wed, 12 Oct 2016 17:35:02 GMT

An example app will be useful but you can always define a value for NULL in apply map function

applymap('map1', 5, null( ) ) or

applymap ('map1', 5, 'XYZ' )

Re: Handle mapping with nulls

pgalvezt — Wed, 12 Oct 2016 19:07:45 GMT

I had to replace Null positions. And change null values.

How to remove NULL values by Mapping Load & Map Using statements... - YouTube