Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sjaiswal13
New Contributor II

Help with Data Model

I have 2 tables A and B.

Table A has many columns 1,2 3........

Table B has many columns 1,2,c.......

i want to first find all matching as well non matching rows based on column 1 that is outer join on that. For all the resulting column 1 , i want to match column 2 for all those rows.

  Composite key is not working as desired.

A
aabbccddee
1a
2b
2c
4j

B
aabbxyz
1a
2b
2c
2d

Thanks