Current Match formula not working properly for 2 3 words

1

Current Match formula not working properly.

I am currently running a match vs a list of products to find a match between 2 lists and then do a lookup as suggested. But when words are similar in the list it doesn’t work. I already tested using contains and start and same issue happens.

Example

List of products

Keyboard and mouse Razer \1500

Wireless keyboard + mouse trust

keyboard Logitech

List of Terms to compare
Keyboard and mouse

wireless keyboard

keyboard

But for example "keyboard and mouse” is still matching just “keyboard”. I also sanitized data such as spaces, uppercase and still not working.

Any ideas? Thank you very much.

2

Also tried ascending and descending sort mode to see if it influences, and same results. Only removing keyboard from the list, makes it actually work.

3

Hi @JoMar ,

Could you please share the sample workflow or a screenshot of the action settings? If you are using the 'Match' action, then it performs a substring search with starts/ends or contains filters, so since "keyboard and mouse Razer" contains "keyboard", it would match that. The order of matches is undefined.

You could instead try to first normalize substrings in the desired order using the Replace with lookup action. The replacement string could be any unique string that does not appear in the column.