Updating the database with external data
Last update: Mon Sep 13 2021 00:00:00 GMT+0000 (Coordinated Universal Time)
- Topics:
- Workflows
CREATED FOR:
- Intermediate
- Developer
The following example 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.
In this example, the reconciliation key used is the email address. The file loaded in the Load file activity is a .txt format file containing the following example data:
lastname;firstname;email;birthdate
jackman;megan;megan.jackman@testmail.com;07/08/1975
phillips;edward;phillips@testmail.com;09/03/1986
weaver;justin;justin_w@testmail.com;11/15/1990
martin;babeth;babeth_martin@testmail.net;11/25/1964
reese;richard;rreese@testmail.com;02/08/1987
cage;nathalie;cage.nathalie227@testmail.com;07/03/1989
xiuxiu;andrea;andrea.xiuxiu@testmail.com;09/12/1992
grimes;daryl;daryl_890@testmail.com;12/06/1979
tycoon;tyreese;tyreese_t@testmail.net;10/08/1971
recommendation-more-help
3ef63344-7f3d-48f9-85ed-02bf569c4fff