Handle mapping with nulls

[pgalvezt]

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!

[jonathandienst]

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.

[rupamjyotidas]

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' )

[pgalvezt · Accepted solution]

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

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