match data rows with template rows

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 !

alte.xlsx

Help

Accepted answers

Sebastiaandb

Hi @JohnnyAlt

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

Greetings,

Seb

Datajointemplate2.yxzp

All comments

Sebastiaandb

Hi @JohnnyAlt ,

Here you go 🙂

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

Greetings,

Seb

Datajointemplate.yxzp

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

Hi @JohnnyAlt

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

Greetings,

Seb

Datajointemplate2.yxzp

JohnnyAlt

Excellent, that's pretty impressive - thanks again !

Sebastiaandb

Hi @JohnnyAlt , glad to help!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703