Can someone help me with the below problem -
I have two tables - Table 1 and Table 2. They have one common column and can be joined.
With Qlikview joins, I can get all rows that are common between them(inner join),all the rows in Table 1 (left join) and all the rows in Table2 (Right join).
But, I am looking to get the below 3 datasets -
1. Inner Rows (Rows common to both Table 1 and Table 2)
2. (Left - Inner Join), Rows in Table 1 minus Common Rows in Table 2 (Left minus Inner join Rows)
3. Similarly, (Right - Inner Join), I want rows in Table 2 minus Common Rows with Table 1 (Right - Inner Join Rows)
I am trying to do this in the load statement but any solution will be great.
I did try exclude statement. Doesn't seem to work.
Thank you for your help.