Match transform with 'Compare Table'

[former_member698220]

Hi All,

I am working on Match (base match) transform to compare data in two tables like KNA1 with Excel file and identify duplicate records by assigning Match score. I have designed job as follows - selected KNA1 table as a source then connected with Base Match transform. In properties -selected 'Customer' & 'ZIP' as input and in options, created Group key = ZIP & Match criteria = 'Customer'. Upon, selected 'Compare table' option and selected - Default action = Compare; Default source = Excel file; Logical soruce field = Customer; In Compare actions table -> I couldnt able to understand what values to pass especially Drive value & passenger values.

Please suggest is the process what I am following is correct to compare two datasets and find duplicate records with match score. I have attached screen prints of the same. Highly appreciate your valueble inputs & suggestions here.

Thanks in advance.

Regards,
Dev

[Julian_Riegel]

Hey there,

You do not need a compare table for your use case as there are just two sources.

Generally, you need to merge the two inputs together before connecting them to the match transform. Make sure you bring them to the same format and take only the fields that you need. Before the merge, create some additional helpful fields such as "SOURCE" to distinguish between the origin of the records after matching has been conducted.

After that, simply follow that blog to set up an initial matching between the records (old but still valid)

https://blogs.sap.com/2013/09/26/how-to-use-match-transform-in-bods-41-for-dedupliation-of-source-da...

Also, this transform is one of the most complex ones in DS with many configuration possibilites, so I suggest also checking the DS Designer Guide and DS Reference Guide for this transform. These guides can be found here:

https://help.sap.com/viewer/product/SAP_DATA_SERVICES/4.2.14/en-US?task=operate_task

Regards,

Julian