Finding same value in different rows in two columns

[JeremyZ]

Hi all, 

Does anyone know how to find same value in different rows in two columns?

Here if the value in "Ref1" column in first row matches the value in "Ref2" column in second row, I will add "match" to the "Comments" column for both two rows.

The same value cannot appear in the same row.

Original:

Ref1	Ref2	Comments
1234	5678
0123	1234
ABC	EFGH
XYZW	ABCDEF
EFGH	ABCD

Desire result:

Ref1	Ref2	Comments
1234	5678	match
0123	1234	match
ABC	EFGH	match
XYZW	ABCDEF
EFGH	ABCD	match

[BS_THE_ANALYST · Accepted solution]

@JeremyZ here's one way (it's a bit scrappy, I've not got much time). I'll refine it shortly

All the best,
BS

[NMangera]

Hi @JeremyZ

[JeremyZ]

@BS_THE_ANALYSTThanks for your help!

But when I try to run my raw data which contains more than 300 rows, the "Append Fields" tool shows error message "There were more than 16 records in the source", how could I fix it? thanks

[martinding]

Hi @JeremyZ,

Here's another approach:

[martinding]

Hi @JeremyZ,

In the Append Tool, you can select allow more than 16 records.

[JeremyZ]

@martinding Thanks for your help!

But the last two rows need to show "match" in "Comment" column as well. 

[JitendraPal]

Hi @JeremyZ you can post this as a weekly challenge, you would have received more responses/solutions to the same problem, anyways I'll also post my approach once I work through it.

on the other hand, you can still submit this as an weekly challenge.

[martinding · Accepted solution]

@JeremyZ 

I see what you mean.

[Christina_H · Accepted solution]

Here's another option