join two table

[saifuddin]

Hi All,

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

Table 1

Table 2

Test2
People_ID	unit_cd
27276155	1234
11166155	6364

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 · Accepted solution]

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]

Thanks for your help. It works perfectly. 

[saifuddin]

Hi 

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

Thanks