match data rows with template rows

[JohnnyAlt]

Hi, new to Alteryx.

We have a spreadsheet with various calculations and would like to try out Alteryx instead.

Would it be possible to replicate the formula in the attachment using Alteryx ?

What does it do - it matches data rows with template rows by checking if a specific column in data row contains any of the strings in the same column of template rows. Both sets can have hundreds of rows. This formula picks up first match only.

The preference would be not to use macros, only simple / standard tools.

Thank you !

[Sebastiaandb]

Hi @JohnnyAlt ,

Here you go 🙂

Let me know if this is what you're searching for!

Greetings,

Seb

[JohnnyAlt]

Thanks a lot, that covers majority of scenarios, I think. What it will not cover is where the search phrase is either a part of word (like "lemo" being part of "lemon") or two words (e.g. searching for "fresh juice"), for example. Both these scenarios are covered by the same Excel formula.

[Sebastiaandb · Accepted solution]

Hi @JohnnyAlt 

Here a altered version that works with phrases and partial words :-). 

Greetings,

Seb

[JohnnyAlt]

Excellent, that's pretty impressive - thanks again !

[Sebastiaandb]

Hi @JohnnyAlt , glad to help!