Data update using reconciliation

Last update: 2021-09-13
  • Created for:
  • Intermediate
    Developer

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;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
    
  • 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.

On this page