Avatar

Level 2

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