Join but populate only first match

[pnair041]

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?

[ShankerV]

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

[ShankerV]

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

[ShankerV · Accepted solution]

Hi @pnair041 

Step 4: Join tool

Step 5:

Hope this helps!!!!

Many thanks

Shanker V

[pnair041]

That was extremely helpful, thank you so much.