Why does CSV upload via "Map CSV to XDM schema" create new records instead of updating existing ones? | Community
Skip to main content
dparraa
Level 2
January 2, 2025
Solved

Why does CSV upload via "Map CSV to XDM schema" create new records instead of updating existing ones?

  • January 2, 2025
  • 1 reply
  • 429 views

Hi everyone,

 

When uploading a CSV file using the Map CSV to XDM schema option in Workflows, I included additional data of a empty columns to complement an existing record in the dataset. However, instead of updating the specified fields, a new record was created. Why does this happen, and is there a specific configuration I might be missing to ensure records are updated rather than duplicated?

 

Regards,

Diego P.

Best answer by ezhil_raja

AEP is an additive platform, and whenever you ingest data, a new record is created. If you want to update existing records, you need to enable the dataset for profile updates, and use Upsert https://experienceleague.adobe.com/en/docs/platform-learn/tutorials/profiles/update-a-specific-attribute-with-upsert

1 reply

ezhil_raja
ezhil_rajaAccepted solution
Level 4
January 2, 2025

AEP is an additive platform, and whenever you ingest data, a new record is created. If you want to update existing records, you need to enable the dataset for profile updates, and use Upsert https://experienceleague.adobe.com/en/docs/platform-learn/tutorials/profiles/update-a-specific-attribute-with-upsert