Skip to Content
avatar image
Former Member

Fuzzy Search to Find Duplicates in Table

Hi,

I want to find duplicates within a table based on First Name column using Fuzzy Search.

Table Tab_001 Definition:

Contact ID  |  First Name

I tried using FUZZY SEARCH in below statement but I get error saying CONTAINS accepts only string as second parameter.

Statement:

SELECT A.CONTACTID AS CONTACTID_A,

A.FIRSTNAME,

B.CONTACTID AS CONTACTID_B,

B.FIRSTNAME,

SCORE() AS SCORE

FROM Tab_001 A

INNER JOIN Tab_001 B

ON CONTAINS(A.FIRSTNAME, B.FIRSTNAME, FUZZY(0.7));

Error: SAP DBTech JDBC: [8]: invalid argument: The second argument cannot include any column: line 8 col 26 (at pos 230)

Any suggestions?

Thanks,

Anoop

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 06, 2016 at 04:58 PM

    Check out this thread for restrictions in CONTAINS Comparing 2 columns in a table using Fuzzy Search | SCN

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Michael.

      Is there any alternative other than fuzzy search to find duplicates in a table (need to identify not just exact duplicates but similar too, just as fuzzy search returns).

      Anoop
      .