Updating the database with external data update-database-file
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 ÃÛ¶¹ÊÓƵ 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
The Update data activity is configured as follows:
recommendation-more-help
3ef63344-7f3d-48f9-85ed-02bf569c4fff