Find and Replace with unique IDs

[Vyx]

Hi All,

Apologies, if this is a little redundant/ obvious - been a little bit of time since I used Alteryx. I have a table that looks like this:

ID	Name	Team 1 Status	Team 2 Status
1	Vyx 1	NA	In Progress
2	Vyx 2	To be assigned	NA
3	Vyx 3	NA	In Progress
4	Vyx 4	To be assigned	Finished
5	Vyx 5	In Progress	NA
6	Vyx 6	Finished	In Progress

I am looking to replace some of the values in Team 1 or Team 2 Status for specific names/ IDs - as some of the status' are duplicated I can't use a simple Find and Replace (or at least haven't figured out how I can)

Appreciate any help you are able to provide. 

Thanks guys!

[afv2688]

Hello @Vyx ,

You could create a table with the names and the values you want to replace using also a joint tool.

You could have the actual value and the value you want it to be for team1 and afterwards with another join for team 2. Giving multiple keys to pair with should easily here solve the problem with the replacing

If this would not solve the issue given the duplicates you are talking about, if you could share with us some specific cases with us we could look into it 🙂

Regards