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?

Join but populate only first match

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

2 James

Tab 2

Record ID Income

1 200

2 300

Desired Output

Record ID Name Income

1 Charles 200

1 Charles

2 James 300

2 James

Any suggestions, please?

Join

Accepted answers

ShankerV

Hi @pnair041

Step 4: Join tool

Step 5:

Hope this helps!!!!

Many thanks

Shanker V

All comments

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

Hi @pnair041

Step 4: Join tool

Step 5:

Hope this helps!!!!

Many thanks

Shanker V

pnair041

That was extremely helpful, thank you so much.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703