Look through 50,000+ rows to determine if numbers in one column are also in another column

[RMotiwalla]

Hello -- 

I am having an issue dealing with over 50K rows of data in which i need to see if invoice numbers found in one column are also in another column. I need to make sure that any matches found are from different rows. Basically I need to take Inv# and look for that number in the payment reference column, the ref key 1 column, the ref key 2 column, and the document column and only indicate a match if they are on different rows.

Any ideas on how to do this?

Thanks!

[MarqueeCrew · Accepted solution]

@RMotiwalla ,

RecordID

Key1

Key2

take this data twice into a join tool. 

JOiN key1=key2

 take the join Output into a FILTER

 recordid != right_recordid

 these are the droids that you're looking for. 

cheers,

 mark

[RMotiwalla]

Thanks Mark, that did the job!

[MarqueeCrew]

Glad to be of service. 

cheers,

 mark