Within one of my modules I use the “Find Replace” tool quite often to find keywords within a customer name field. By chance, I have found that irrespective of what order my keywords are sorted in, Alteryx will look at each word in the customer name and try to match them in order.
For example, the customer name of EAST RIDING YORKSHIRE COUNCIL, when matched to my list of keywords matches the word RIDING before it matches the word COUNCIL, even though COUNCIL appears higher up my list than RIDING does.
I would like to be able to prioritise my keywords so that Alteryx starts at the top and works its way down my list of keywords, rather than just taking the first word in a customer name that matches any of my keywords. Is this possible?