Left JOIN problem

[shovongoutam]

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.

[martinpohl · Accepted solution]

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