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

Duplicates in delivery included but important/unique data field is overwritten

Avatar

Avatar
Validate 1
Level 2
AC_Bella
Level 2

Likes

6 likes

Total Posts

14 posts

Correct Reply

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

Avatar
Validate 1
Level 2
AC_Bella
Level 2

Likes

6 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
AC_Bella
Level 2

06-02-2019

Hello,

I am trying to create a delivery where duplicates are kept. I managed to keep the duplicates but unfortunately another data field – the one that is most important in my case – is randomly overwritten with data of another entry of the duplicate.

Here an example for selected data:

ID

Name

Account No.

121 555 555

Vivien Test

8.901.444.777

121 555 555

Vivien Test

7.693.333.222

121 555 555

Vivien Test

2.369.888.666

Here the corresponding csv extraction file:

ID

Name

Account No.

121 555 555

Vivien Test

8.901.444.777

121 555 555

Vivien Test

8.901.444.777

121 555 555

Vivien Test

8.901.444.777

As you can see, the duplicates are kept but the unique account no. is changed to one of the account numbers of the duplicates. I checked typology rules and format of the extraction file but couldn’t find any hint to why this happens.

Do you have any ideas how I can solve this?

Thanks in advance,

Bella

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Contributor
MVP
wodnicki
MVP

Likes

938 likes

Total Posts

1,061 posts

Correct Reply

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

Avatar
Contributor
MVP
wodnicki
MVP

Likes

938 likes

Total Posts

1,061 posts

Correct Reply

495 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile
wodnicki
MVP

07-02-2019

Linked? What happens if you copy the linked fields into the working table in Query activity (Complementary information/Add data)?

Answers (5)

Answers (5)

Avatar

Avatar
Contributor
MVP
wodnicki
MVP

Likes

938 likes

Total Posts

1,061 posts

Correct Reply

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

Avatar
Contributor
MVP
wodnicki
MVP

Likes

938 likes

Total Posts

1,061 posts

Correct Reply

495 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile
wodnicki
MVP

06-02-2019

This is an external delivery with account no. as an enriched col?

Avatar

Avatar
Validate 1
Level 2
AC_Bella
Level 2

Likes

6 likes

Total Posts

14 posts

Correct Reply

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

Avatar
Validate 1
Level 2
AC_Bella
Level 2

Likes

6 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
AC_Bella
Level 2

15-02-2019

The problem is solved! And I refrained from using Target Mapping - a little bit to risky for my liking. Your comment

helped in the end. I didn't know that I could add the additional data to the extraction file of delivery - a friend suggested that. And it works! All individual account numbers are kept and assigned to the right person.

Thx for your help!

Avatar

Avatar
Contributor
MVP
wodnicki
MVP

Likes

938 likes

Total Posts

1,061 posts

Correct Reply

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

Avatar
Contributor
MVP
wodnicki
MVP

Likes

938 likes

Total Posts

1,061 posts

Correct Reply

495 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile
wodnicki
MVP

14-02-2019

An alternative could be replacing the delivery file with an extract post-send, with the extract selecting out of the temp table. Messy though.

Avatar

Avatar
Validate 1
Level 2
AC_Bella
Level 2

Likes

6 likes

Total Posts

14 posts

Correct Reply

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

Avatar
Validate 1
Level 2
AC_Bella
Level 2

Likes

6 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
AC_Bella
Level 2

13-02-2019

Sorry for the late response!

With linked I meant the relation between recipient table and the account no.-table.

The delivery does not care about the added data in query. It takes the data which is labeled as target group and "reselects" the other data. If the target group has duplicates, the same data for each one is selected even if there are more account numbers than one...

I tried Target mapping (changing target group in delivery from recipient to acoount no.-table) but couldn't get it to work yet. I think this one is my best bet

Avatar

Avatar
Validate 1
Level 2
AC_Bella
Level 2

Likes

6 likes

Total Posts

14 posts

Correct Reply

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

Avatar
Validate 1
Level 2
AC_Bella
Level 2

Likes

6 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
AC_Bella
Level 2

07-02-2019

I am using the direct mail channel. So a csv file will be generated with all relevant data. The account no. belongs to a table linked to recpient table which I selected as target dimension.

I just realised where the problem lies: even if I have the correct data selected beforehand the extraction file uses the target group (here: Vivien Test incl. email address) to select the data for the file anew. Since some keys occur multiple times, the first data found in the database is linked to all of them - other entries are ignored.

Is there a possibility to tell the delivery which data should be used as "base" (in my case account no.) to map other data to for the file? I am not sure but could "Target Mapping" be an option?