Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
sjaiswal13
Contributor II
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

0 Replies