Mapping Rule Help

[Samowens30]

Hey Alteryx Heroes,

i am stuck on a workflow and could use some inspiration. I am using find and replace append to select a brand from a cell description and input into a brand column.

ie 

“xyzApple56z” = Apple

“ZMicrosoft67dd” = Microsoft 

etc.

This works perfectly until there is two brands in a description. If it says “Apple & Microsoft” in the description, i want it to say “Mix”. However, in the rules table where it scans for the words within the cell, it just see’s Apple so stops reading further and only selects this one.

Any ideas how I can get it to select mix instead? It can even be a new part of the workflow where it overwrites the errors made in the find replace.

thanks in advance!!

Sam

[Samowens30]

Am not too sure what you have done here to get to the end result (of which looks good!). Could you provide a little more detail on what the workflow is doing? Thanks so much!

[atcodedog05]

@Samowens30 

the above workflows should work.

[atcodedog05]

Hi @Samowens30 

Here is the output with your data.

And here is the modified workflow🙂

Hope this helps 🙂

[Samowens30]

You're a legend!!!!!!!!!!!!! Thank you!! 🙂

[atcodedog05]

Happy to help 🙂 @Samowens30 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂