Skip to Content

Match transform with 'Compare Table'

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

1.png (68.9 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jul 16, 2020 at 10:17 AM

    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-data/

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.