Discussion board where members can get started with Qlik Sense.
I have two table similar to the one bleow
Fld1 Fld2 Fld3 Fld4
AA X1 Y1 0.123
AA X2 Y1 0.234
AA X2 Y2 1.2
BB - - 2.2
Fld1 Fld2 Fld3 Fld5
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)
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.
View solution in original post