Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Comparing concatenated strings to remove duplicates

maheswarik23685
Level 4
Level 4

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

1 Accepted Solution
wodnicki
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post

1 Reply
wodnicki
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post