Hi, community
I have 2 tables with a unique ID, where I'm looking to populate a column from another table without duplicating the records.
Table A
ID | Name | Job ID |
1 | A | 1 |
2 | B | 1 |
3 | C | 2 |
4 | D | 3 |
5 | B | 3 |
6 | A | 2 |
7 | E | 4 |
8 | E | 8 |
Table B
Job ID | Job Name |
1 | ABC |
2 | CDE |
3 | DEF |
4 | EFG |
5 | FGH |
6 | GHI |
7 | HIJ |
Desired Output
ID | Name | Job ID | Job Name |
1 | A | 1 | ABC |
2 | B | 1 | ABC |
3 | C | 2 | CDE |
4 | D | 3 | DEF |
5 | B | 3 | DEF |
6 | A | 2 | CDE |
7 | E | 4 | EFG |
8 | E | 8 |
Solved! Go to Solution.
hi @Anuj_1196
I understand that you want to have Left Outer Join results. Please see the attached WF.
By using Multiple Join tool ,you can easily obtain all type of JOIN operation(Full Outer join, Left Outer Join, Right Outer join, Inner Join) like this. This is just for your information.
@Anuj_1196
Or we can just use a Join tool then union the L and J data together.