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
