selecting a pattern in two different column list

Hello,in

I need help as i couldnt match the same patterns in two different column . This will not be only one pattern.

Let me explain as below:

If a pattern in column b menu matches a pattern in column a, write ‘1’ in column c
For example

pattern matching.xlsx (10.5 KB)

many many thanks :))))

Hi @deepblueish

See this wf selecting_pattern.knwf (37.0 KB). It loops every row (of column b) to see if the character is present in column a. It is a solution with a loop, so if you have a really big data set, you may encounter performance issues.

.
gr. Hans

1 Like