Comparing concatenated strings to remove duplicates

maheswarik23685

25-01-2019

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

Accepted Solutions (1)

Accepted Solutions (1)

wodnicki

MVP

25-01-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

Answers (0)