AnsweredAssumed Answered

Find matching fields

Question asked by fmpro_novice on Sep 9, 2016
Latest reply on Sep 9, 2016 by philmodjunk

How do I find matching fields over the entire data base?

 

In this example, each line represents a record and each number represents a specific field. Notice that lines 4 & 5 are exact duplicates and lines 8 & 9 are exact duplicates.

 

1. 29     30     19     21     59

2. 31     29     22     20     60

3. 29     31     20     21     60

4. 32     29     22     19     61

5. 32     29     22     19     61

6. 33     29     22     19     62

7. 33     29     19     22     62

8. 34     30     21     21     64

9. 34     30     21     21     64

 

In this example, I need to find and alert that lines 4 & 5 are exact matches, and I need to find and alert that lines 8 & 9 are exact matches.

 

Seems like this should be very easy, but I can't figure it out.

 

Thank you.

Outcomes