Avatar

Correct answer by
Level 2

Hi There,

You can simply connect the import activity to an update activity.

To configure the update settings open the activity by clicking on it:

  1. Specify the operation (insert/update/delete, etc): in this case "insert or update"  as we want to insert new records or update in case the data already exists in the destination table.
  2. Select the table to insert the imported data into (recipients in this example)
  3. Select 'Unsing reconciliation keys'  as Recrod Identification method and define the reconciliation key(s). (keys for finding records) (email address in this example:  "email" field from the recipient table to "EmailAddress" field of import file)
  4. Then map the fields from your import file to the fields of the destination table under "fields to update":

1623255_pastedImage_0.png

So Campaign now tries to find an exising record based upon email-address (in this example) and updates the record when it finds one, otherwise inserts a new record.

Kind Regards,

-Menno

View solution in original post