Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
I had to replace Null positions. And change null values.
How to remove NULL values by Mapping Load & Map Using statements... - YouTube
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.
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' )
I had to replace Null positions. And change null values.
How to remove NULL values by Mapping Load & Map Using statements... - YouTube