community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Matching strings in same row

Meteor

I'd like to identify all rows where column A, matches some string of data in any column between B-E. The match could appear anywhere in columns B-E. How would I call out those rows where a match of some kind exists? I've controlled for punctuation and case, but I'd like to do an exact match, and then fuzzy match to see the difference.

 

Thanks!

Pulsar

Does this help you?

 

I basically combined Columns 2-5 and then check if Column 1 is contained in the combined set.

 

I you want to can either join back to the original dataset on RecordID to get the the matching rows in the original format or parse it out with a text to columns tool.

 

 

matching strings.png

Magnetar
Magnetar

Another option would be a formula to capture matches.


Something like:

IF CONTAINS([Column B],[Column A]) OR CONTAINS([Column C],[Column A]) OR CONTAINS([Column D],[Column A]) OR CONTAINS([Column E],[Column A]) THEN 1
ELSE 0
ENDIF


There are methods to make this more dynamic if you need additional fields compared.

Labels