Comparing concatenated strings to remove duplicates

Avatar

Avatar
Validate 10
Level 3
maheswarik23685
Level 3

Likes

21 likes

Total Posts

32 posts

Correct reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
maheswarik23685
Level 3

Likes

21 likes

Total Posts

32 posts

Correct reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
maheswarik23685
Level 3

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)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
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)