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

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
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile

Avatar
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
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)