Comparing concatenated strings to remove duplicates | Community
Skip to main content
maheswarik23685
maheswarik23685
Level 3
January 25, 2019
Solved

Comparing concatenated strings to remove duplicates

  • January 25, 2019
  • 1 reply
  • 2036 views

Hi All,

1. concatenated string from incoming files  ex: firstName+LastName+email -->string1

2. concatenated string from recipient table ex:f irstName+LastName+email -->string2

We need to compare above two concatenated strings and if string1 is not equal to string2  we need to insert to a custom table say lead .If the strings are same we need to reject that record from incoming file.

We need to check for 8 concatenated strings in similar way for each incoming record .

How to implement it? Let me know if anyone have idea on it.

Thanks,

Maheswari

    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 Jonathon_wodnicki

    Hi,

    Use an enrichment to left-join the tables on your concatenations, then split on empty key for right-side table, sending empty rows to an update activity for your custom table and the complement to an extract activity.

    Thanks,

    -Jon

    1 reply

    Jonathon_wodnicki
    Community Advisor
    Jonathon_wodnickiCommunity AdvisorAccepted solution
    Community Advisor
    January 25, 2019

    Hi,

    Use an enrichment to left-join the tables on your concatenations, then split on empty key for right-side table, sending empty rows to an update activity for your custom table and the complement to an extract activity.

    Thanks,

    -Jon

      Terms & ConditionsAccessibility statement

      Loading footer...