Hi, I am working on an engagement that requires me to join multiple tables, however, I wish to populate only the first match and not the entire data. For eg:
Tab 1
Record ID Name
1 Charles
1 Charles
1 Charles
2 James
2 James
Tab 2
Record ID Income
1 200
2 300
Desired Output
Record ID Name Income
1 Charles 200
1 Charles
1 Charles
2 James 300
2 James
Any suggestions, please?
Solved! Go to Solution.
Hi @pnair041
Please have the unique from the dataset 1.
Then do the join with D1 and D2.
Then union the output for unique false node and J node of Join.
Many thanks
Shanker V
Hi @pnair041
Please find the sample use case for your scenario.
Step 1: Input data1.
Step 2: Input data2.
Step 3:
Many thanks
Shanker V
That was extremely helpful, thank you so much.