topic Re: join two table in QlikView

join two table

saifuddin — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I need help with some task I was trying to do. Essentially, I want to join two tables.

Table 1

Table 2

Desire output

Basically, I want to keep all the rows from the left table and only want to keep common rows from the right table.

But, using left join only gives rows from the left table and using concatenation gives everything

Regards

Saif

MayilVahanan — Thu, 02 Apr 2020 07:53:24 GMT

Hi Saifuddin

Try like below

Ta:
LOAD * Inline
[
People_ID,unit_cd
27276155,3611
];

Tb:
Load * Inline
[
People_ID,unit_cd
27276155,1234
11166155,6364
]Where Exists(People_ID);

saifuddin — Thu, 02 Apr 2020 22:57:09 GMT

Thanks for your help. It works perfectly.

saifuddin — Thu, 16 Apr 2020 22:54:24 GMT

it works fine but it creates a synthetic key. How do I avoid that?

Thanks