Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
suraj_spins
Partner - Contributor
Partner - Contributor

Help in doing a Join on multiple fields. Join with * if it has no values.

Hi All,

I am trying to join two tables with multiple columns. A regular join but if values are missing in one of the columns it should join on all possible field attributes. If not null then consider the value in the field. Below is the example. Any help is appreciated, Thank you.

A:

 

ABCDE
aILa4430blue
bCAs6631yellow
cNYn2832Green
dFLb3633Red
eCOl5034Red
aAZa4435blue
bMNs6636yellow
cCAn2837Green
dMAb3638Red
eNVl5039Red

B:

 

ABCDEF
aa44blueNike
bCAs6631yellowPuma
cCAn28GreenReebok
db36RedNike
eNVl50RedAdidas

Result:

 

ABCDEF
aILa4430blueNike
bCAs6631yellowPuma
cNYn2832Green
dFLb3633RedNike
eCOl5034Red
aAZa4435blueNike
bMNs6636yellow
cCAn2837GreenReebok
dMAb3638RedNike
eNVl5039RedAdidas
1 Reply
Anonymous
Not applicable

if you do it like that you have 5 Key Fields,

the matching will only work if all of the 5 fields match.

So what is/are your key field(s)?