- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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:
- 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.
- Select the table to insert the imported data into (recipients in this example)
- 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)
- Then map the fields from your import file to the fields of the destination table under "fields to update":
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
Views
Replies
0 Likes
Total Likes