Find and Replace, but return all matches?

lmanda

Hi all,

I am trying to find a way to see if a column contains a value, return all the corresponding values from another column?

My current workflow (also attached)...:

For each Combo, find replace only returns one account:

How can I make it return all accounts that correspond to the Combo? I.e. return both 82463 and 82486 for AP, and 12345 and 23456 for HA?

findreplacehelpv2.yxmd

atcodedog05

Hi @lmanda 

In your scenario, you can use a join tool instead.

Workflow:

Find and replace will always only return the first match.

Hope this helps : )

findreplacehelpv2.yxmd