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
pattern matching.xlsx (10.5 KB)
many many thanks :))))
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.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.