The Update data activity can be used after importing a file in order to insert the data recovered into the Adobe Campaign database. Several options allow you to personalize updating the data.
The Batch size field enables you to define the maximum batch size for the data to upload.
In the Fields to update tab, specify the fields on which the update will be applied and, if necessary, add conditions so that this update is carried out. To do this, use the Taken into account if column. The conditions are applied one after the other in list order. Use the arrows on the right to change the order of the updates. You can use the same destination field multiple times.
You can automatically link fields using the button. Automatic linking detects fields with the same name.
During an Insert or update type operation, you can individually select the operation to apply for each field. To do this, select the value you would like in the Operation column.
Managing updates The lastModified , modifiedBy , created and createdBy fields are automatically updated when an update data activity is run, unless their configuration is explicitly carried out on the field update table. The update is only carried out on the records where at least one difference has been detected. If the values are the same, no update is carried out.
If needed, manage the activity's Transitions to access the advanced options for the outbound population.
The following activity shows the configuration of an Update data activity following a Load file activity. The aim of this workflow is to add or update profiles to the Adobe Campaign database with the data recovered from the file. The reconciliation key used is the email address.
lastname;firstname;email;birthdate jackman;megan;email@example.com;07/08/1975 phillips;edward;firstname.lastname@example.org;09/03/1986 weaver;justin;email@example.com;11/15/1990 martin;babeth;firstname.lastname@example.org;11/25/1964 reese;richard;email@example.com;02/08/1987 cage;nathalie;firstname.lastname@example.org;07/03/1989 xiuxiu;andrea;email@example.com;09/12/1992 grimes;daryl;firstname.lastname@example.org;12/06/1979 tycoon;tyreese;email@example.com;10/08/1971