Load file load-file

The Load file activity is a Data management activity. Use this activity to work with profiles and data stored in an external file. Profiles and data are not added to the database, but all fields in the input file are available for personalization, or to update profiles, or any other table.

NOTE
Supported file formats are: text (TXT) and comma-separated value (CSV).

This activity can be used with a Reconciliation activity to link unidentified data to existing resources. For example, the Load file activity can be placed before a Reconciliation activity if you import non-standard data into the database.

Configure the Load file activity load-configuration

Follow these steps to configure the Load file activity:

  1. Drag and drop a Load file activity into your workflow. Click the Select from file button.

  2. Select the local file to use. The format must be aligned with this sample file.

  3. Preview and check how data is mapped in the central section of the screen.

  4. Use the Columns section in the left pane to adjust the data type and width for each column.

  5. In the Formatting section located under the columns configuration, specify how the external file is formatted to ensure that data is correctly imported.

  6. Click Confirm once settings are correct.

Example load-example

A sample of an external file loading used with the Reconciliation activity is available in this section.

recommendation-more-help
c39c2d00-ba9a-424b-adf9-66af58a0c34b