Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Left JOIN problem

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.

1 Solution

Accepted Solutions
Partner
Partner

Re: Left JOIN problem

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

View solution in original post

1 Reply
Partner
Partner

Re: Left JOIN problem

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

View solution in original post