6 Replies Latest reply on Sep 9, 2016 2:12 PM by philmodjunk

    Find matching fields

    fmpro_novice

      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.