Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have two table similar to the one bleow
Table1:
Fld1 Fld2 Fld3 Fld4
AA X1 Y1 0.123
AA X2 Y1 0.234
AA X2 Y2 1.2
BB - - 2.2
Table 2
Fld1 Fld2 Fld3 Fld5
AA X1 Y1 0.123
AA X2 Y1 0.234
AA X2 Y2 1.2
BB - - 2.2
If I poerform a left join to Table 2.... Fld5 value for BB is (Null)....
Probably due to Fld2 Fld3 match was not found.
Can anyone help in Achieving this?
Is it wise to use MAPPING? In that case I can not find proper explanation to subfields mapping.
Thank you in advance.
a join only matches to a value, null is not a value
when do a mapping load it may work, but you have to do a mapping load for all fields you want to map individual (mapping load only works with two fields)
Map1:
mapping load
Fld1&'-'&Fld2'-'&Fld3'-'&Fld4 as Key,
Fld5 as Map1
from your source;
Because of the dashes between values you will get a BB--2.2 value to compare.
Regards
a join only matches to a value, null is not a value
when do a mapping load it may work, but you have to do a mapping load for all fields you want to map individual (mapping load only works with two fields)
Map1:
mapping load
Fld1&'-'&Fld2'-'&Fld3'-'&Fld4 as Key,
Fld5 as Map1
from your source;
Because of the dashes between values you will get a BB--2.2 value to compare.
Regards