Lookup with Multiple Matches

Hello!!

I have this situation where I have a key to two tables (Rel ID). I want to join these tables together using the Rel ID, but I know there are multiple matches. When I use the Find & Replace tool, it only gives me the first match. I want all the matches not just the first one.

Example:

Thank you!!!

Help

Join

Accepted answers

AngelosPachis

Hi @Kristie_Pires ,

Try adding a union after your join tool and connect the J output anchor and whatever drops out from Table 1. That should give you what you're after

example.yxmd

All comments

AngelosPachis

Hi @Kristie_Pires ,

Try adding a union after your join tool and connect the J output anchor and whatever drops out from Table 1. That should give you what you're after

example.yxmd

Kristie_Pires

Thank you so much @AngelosPachis ! That's all I needed 😊

urbot

How to bring match values under one row example: 1. Banna in fruit column and green, yellow in color column as one row.example 2. Apple and then yellow, Red, yelllow (remove duplicate matches if any in a cell)

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703