Check if String in Column A Matching with Column B

[VijayGopal]

Hi All,

I'm working on the following problem to check if the strings match. Thank you in advance for your assistance.

Column A	Column B	Check
1234, 1122,1231	1231,1234,1122	True
2233,1133	2233,1111	False
0011,1144	0011	False

[KGT]

A conditional statement will get you there.

If [Column A]==[Column B] THEN 1 ELSE 0 ENDIF

[flying008]

Hi, @VijayGopal 

FYI.

[ntakeda]

Since Alteryx does not allow direct comparison of lists, you should first expand them.

Then, sort both ColumnA and ColumnB in ascending order and assign row numbers to each item.

Next, compare the items with the same row number. If any pair is different, return false.

A sample workflow has been created.
Please check the workflow for more details.