How to use Duplicate rule in Mapping

Please find the rule in attached screenshot  to check the duplicate entry of EmpSSN and ElectionCode repeats in more than one record in a source file.  Then there will be no duplicacy and only one unique record will be picked up from the source file.

Duplicate.png

Have more questions? Submit a request

2 Comments

  • 0
    Avatar
    David Paras

    Want to update a column in case of duplicate records. Or filter out both records. For each condition

    /Root/Record [(preceding:: Material = Material) or (following:: Material = Material)]

    What if I need to filter both the duplicates?

  • 0
    Avatar
    David Paras

    for Filtering both the duplicates(preceding and following) you need to apply both the Axis Functions "preceding" as well as "following" in ForEach.

    Apply the below ForEach condition to filter both the duplicates:

    "$Input_Source_Schema/Root/Record[not(preceding::Source_Column1 = Source_Column1) and not(following::Source_Column1 = Source_Column1) ]"

Article is closed for comments.