Identifying Duplicates in BOBJ Data services

[Former Member]

Hi all,

I would like to identify duplicate records in BOBJ Data services. Which is the appropriate transform to identify duplicate records.? For Example: i have material numbers with each having three characteristic values. If two MATNRs match by 3 characteristic values, then it should be identified as duplicates with a match score 100. If two MATNRs match by 2 characteristic values, then it should be identified as duplicates with a match score 80. If two MATNRs match by 1 characteristic value, then it should be identified as duplicates with a match score 60. How can this concept be implemented in BOBJ Data services.?? could anyone give a comprehensive explanation on this ???

Thanks,

OMAR.

[former_member182007]

Hello Omar,

The Match transform.identifies duplicate records at multiple levels within a single pass for individuals, households, or corporations within multiple tables or databases and consolidates them into a single source.

you can see below link for more info

http://wiki.sdn.sap.com/wiki/display/BOBJ/DQMatchTransform

hth

thx

deep

[denise_meyer]

Omar,

The Match transform would be the best option for you to use to achieve the scenario you describe below. The Match transform will compare strings and then provide a match score on output. This match score is based on number of characters that match vs total number of characters - so it may not give you the exact score you are looking for here, but you can play around with the options in the match transform to affect what "score" that it calculates is considered a match.

Please read in the Designer guide more about the Match transform or in the technical guides. Also, you must have a Data Qualiity license with Data services for the match transform to be available to you.

Hope this helps.

Thanks

Denise Meyer

SAP Support