Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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);
Thanks for your help. It works perfectly.
Hi
it works fine but it creates a synthetic key. How do I avoid that?
Thanks