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

ACS - Duplicate profiles after Update action

Avatar

Avatar
Validate 10
Level 3
eveline8
Level 3

Likes

24 likes

Total Posts

70 posts

Correct Reply

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

Avatar
Validate 10
Level 3
eveline8
Level 3

Likes

24 likes

Total Posts

70 posts

Correct Reply

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

27-03-2018

Hi all,

I can't understand why the Update action in an import workflow duplicates the profiles.

I explain better:

I have this workflow:

wkfimport.png

The file csv that I have to import has different columns. We have a customer ID, emails, first name and so on.

In the file there are 221.506 profiles with these caractheristics:

- for one email we can have different customer ids ( play@ggg.com can have 5 different customer id)

- for one customer id we can have only one email

The strange thing is when there is a Update action (insert or update profiles) with reconciliation criteria by Customer id and email, the outgoing population is larger than the incoming population.

There are about 500 duplicate profiles.

I can't understand why the update action duplicate the profiles.

Someone have any suggestion?

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 10
Level 3
eveline8
Level 3

Likes

24 likes

Total Posts

70 posts

Correct Reply

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

Avatar
Validate 10
Level 3
eveline8
Level 3

Likes

24 likes

Total Posts

70 posts

Correct Reply

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

18-04-2018

Hi David,

sorry for my late.

I checked and I don't have duplicates.

I solved the problem by setting the reconciliation criteria only by Customer IDs because I am sure that they are unique.

This setting works fine.

Thanks,

Eveline

Answers (4)

Answers (4)

Avatar

Avatar
Boost 5
Level 2
davidk21713691
Level 2

Likes

5 likes

Total Posts

27 posts

Correct Reply

9 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Affirm 5
Affirm 3
View profile

Avatar
Boost 5
Level 2
davidk21713691
Level 2

Likes

5 likes

Total Posts

27 posts

Correct Reply

9 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Affirm 5
Affirm 3
View profile
davidk21713691
Level 2

30-03-2018

Hi Alexandre,

in my case the reconciliation is used to have an idea of existing profiles vs new profiles.

@eveline8: can you check in your profiles table if you have duplicate on customer ID and email?

Thanks

Avatar

Avatar
Validate 1
Level 3
arouillard44
Level 3

Likes

18 likes

Total Posts

53 posts

Correct Reply

9 solutions
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back
Boost 5
View profile

Avatar
Validate 1
Level 3
arouillard44
Level 3

Likes

18 likes

Total Posts

53 posts

Correct Reply

9 solutions
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back
Boost 5
View profile
arouillard44
Level 3

30-03-2018

Hello David,

I'm doing the same thing to Insert or Update my customer, and I have a custom ID too. I don't understand why you're using a reconciliation activity in your workflow ?

Here you can see mine :

1454453_pastedImage_0.png

My reconciliation with Profile table is directly in the Update data activity :

1454454_pastedImage_1.png

Regards,

Alexandre

Avatar

Avatar
Validate 10
Level 3
eveline8
Level 3

Likes

24 likes

Total Posts

70 posts

Correct Reply

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

Avatar
Validate 10
Level 3
eveline8
Level 3

Likes

24 likes

Total Posts

70 posts

Correct Reply

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

29-03-2018

Hi David,

I confirm that in the file there aren't empty values in the email and customer id fields.

Eveline

Avatar

Avatar
Boost 5
Level 2
davidk21713691
Level 2

Likes

5 likes

Total Posts

27 posts

Correct Reply

9 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Affirm 5
Affirm 3
View profile

Avatar
Boost 5
Level 2
davidk21713691
Level 2

Likes

5 likes

Total Posts

27 posts

Correct Reply

9 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Affirm 5
Affirm 3
View profile
davidk21713691
Level 2

28-03-2018

Hi Eveline,

Can you please confirm if the email field in your file have some empty value (assuming that your customer ID is not nullable)?

If it's the case then you need to add a default value (example 0) instead of keeping the empty value.

The reason is ACS is not able to identify empty field when doing a reconciliation or data update.

Thanks

David