Lookup with Multiple Matches

[Kristie_Pires]

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!!! 

[AngelosPachis · Accepted solution]

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

[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)