Hi,
I am new to Alteryx and currently facing an issue.
I have list of key words and I want to flag off that sentence if the sentence contains that word.
But the issue is it not only flags of the
Ex: Key word - MAT
Sentence 1- MEETING SCHEDULE WITH MAT AT 10 AM
Sentence 2- ACCOUNTS NEED TO BE AMALGAMATED
Solved! Go to Solution.
Do you want to match first record and not the second ?
contains([Field1],'MAT') : matches both
contains([Field1],' MAT ') or REGEX_Match([Field1], '.*( MAT ).*') : matches first