Contains Within for multiple Iterations

1

Hi,

We have a column - and we want to search each row of that column to check if it has a specific substring. However, we have 250 substrings that we want to check, and we want to check each row in the column.

So so far, we using a nested if statement - 250 of them. We generate the If statement outside of easymorph, in a way that keeps everything orderly. We then copy and paste the nested If statement into a step on EasyMorph.

Is there any function/approach that could render the same result a little more elegantly.

Rob

2

Hi Rob,

the “Match” action does exactly that – it searches all rows of a column for substrings from a list in another table. There are multiple search modes available - contains, starts with, ends with, and fuzzy matching.

3

Ahaaaaa, thank you!