How to Reject the dublicate records without using deduplication activity | Community
Skip to main content
V
vani97
Level 4
February 24, 2024
Solved

How to Reject the dublicate records without using deduplication activity

  • February 24, 2024
  • 2 replies
  • 809 views

Hi ,

 

Let assume that we are having the duplicate record in csv file that has uploaded in data loading file activity from those extracted data we need to remove the duplicate record 

Note: Without using Deduplication activity .

Does anyone help me on this .


@_manoj_kumar_ @parthasarathy  @vraghav 

Can anyone help on this


This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by AkshayAnand

Hi @vani97 

 

I guess you can achieve this through nested JavaScript using loop. You can select the records from the temp table, store them in an array object in JSON having email and PKid, now taking a single record iterate it to find the duplicates and keep recording the duplicates ID, after iterating through the full array using loop you can delete the recorded ids.

 

Hope it helps.

 

Thanks

Akshay

2 replies

ParthaSarathy
Community Advisor
ParthaSarathyCommunity Advisor
Community Advisor
February 26, 2024

Hi @vani97 ,

To identify a duplicate records, we need to specify ACC that on what field to be considered for identifying duplicate. Data loading activity don't have an option to identify the duplicate records. So, you have to use deduplication activity to perform this action.

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    AkshayAnand
    Community Advisor
    AkshayAnandCommunity AdvisorAccepted solution
    Community Advisor
    February 26, 2024

    Hi @vani97 

     

    I guess you can achieve this through nested JavaScript using loop. You can select the records from the temp table, store them in an array object in JSON having email and PKid, now taking a single record iterate it to find the duplicates and keep recording the duplicates ID, after iterating through the full array using loop you can delete the recorded ids.

     

    Hope it helps.

     

    Thanks

    Akshay

      Terms & ConditionsAccessibility statement

      Loading footer...