Find & Replace the same vale in all rows

Hi Experts,

I need you input how to build a work flow which check a specific value in column and replace the same value in all other rows based on the first column common value.

Here is an example like India (first column has multiple values in 2nd column) If India has any value as mango replace all other fruits as mango in below. Could you let me know how to achieve the same in alteryx .

Screenshot 2026-03-06 214957.png Screenshot 2026-03-06 215006.png

Alteryx Editions

Accepted answers

jrlindem

Okay, I was able to get something built out quicker. Take a look at this (below). There's, of course, extra pieces just to show you what's going on but you can slim this down if needed....

Workflow is also attached. -Jay

jrlindem_example.yxmd

cjaneczko

Here is one way to do it.

All comments

jrlindem

You can do this by filtering to rows that have "Mango" and then making distinct. Then join that back to the original list (or append using Find Replace) for only those matching countries. Where there wasn't a row with Mango it won't have a value to join/append.

Let me know if that helps, otherwise, I can build a mock up a little later. -Jay

jrlindem

Okay, I was able to get something built out quicker. Take a look at this (below). There's, of course, extra pieces just to show you what's going on but you can slim this down if needed....

Workflow is also attached. -Jay

jrlindem_example.yxmd

cjaneczko

Here is one way to do it.

Kottapally_Ramesh

Hi Akhilesh,

Attached is the workflow as per your requirements.

Find & Replace the same value.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703