Data update using reconciliation
The following example demonstrates a workflow that creates an audience of profiles directly from an imported file containing new clients. It is made up of the following activities:
- A Load file activity, which loads and detects tshe data of the file to import. The imported file contains the following data:
lastname;firstname;email;dateofbirth jackman;megan;firstname.lastname@example.org;07/08/1975 phillips;edward;email@example.com;09/03/1986 weaver;justin;firstname.lastname@example.org;11/15/1990 martin;babeth;email@example.com;11/25/1964 reese;richard;firstname.lastname@example.org;02/08/1987 cage;nathalie;email@example.com;07/03/1989 xiuxiu;andrea;firstname.lastname@example.org;09/12/1992 grimes;daryl;email@example.com;12/06/1979 tycoon;tyreese;firstname.lastname@example.org;10/08/1971
- A Reconciliation activity, which links each column of the loaded file to a profile dimension column. The file records that cannot be identified (missing data, incompatible data type, etc.) are ignored to preserve the integrity of the final audience data.
- A Save audience activity, which saves the audience of profiles.