Update
The Update Data Action determines whether a record in the Selection results is new or existing. For new records, Unaric Segment adds them to the end of the Target Data Extension. For existing records, the system updates the record with the result data. This action requires the use of a Primary Key, which serves as a reference to check record existence.
Example
Assume the Target Data Extension contains the following data before running the Selection:
Customer ID | First Name | Last Name | Language | |
|---|---|---|---|---|
C-100 | Jane | Jones | English | |
C-101 | Kofi | Abimbola | Dutch | |
C-102 | Paul | Chang | English | |
C-103 | Maria | Juarez | Spanish |
Sample Selection results:
Customer ID | First Name | Last Name | Language | |
|---|---|---|---|---|
C-100 | Jane | Jones | French | |
C-102 | Paul | Chang | Chinese | |
C-112 | Bjorn | Svenson | Swedish | |
C-104 | Marie | Benoit | French |
After running the Selection, the updated Target Data Extension will contain the following data (with Primary Key Customer ID): The final data in the Target Data Extension will be sorted by Primary Key and the existing records (in Italics) will be updated with the data from the Selection results.
Customer ID [PK] | First Name | Last Name | Language | |
|---|---|---|---|---|
C-100 | Jane | Jones | French | |
C-101 | Kofi | Abimbola | Dutch | |
C-102 | Paul | Chang | Chinese | |
C-103 | Maria | Juarez | Spanish | |
C-112 | Bjorn | Svenson | Swedish | |
C-104 | Marie | Benoit | French |