Skip to Content
0
Former Member
Aug 09, 2008 at 08:57 AM

Matching Strategy

35 Views

Hi all

we have foll requirements:

Main Table: Name1,City, Zip

User is entering search parameters in EP screen on Name1 city and Zip and we need do show duplicate records by running matching strategy defined.

Requirement is if (initial 6 letters of Name1) and City and Zip matches score=90.

If initial 4 letters of Name1&city& zip matches score=50.

If initial 2 letters of name1,city and zip matches score=20.

Pls advise on how to do this.

thanks

Ravi