Email Manager - CAMPAIGN BUILDER

HOME

Editing Lookup Tables

Lookup Tables can be edited by:

  • Re-importing the file
  • Updating or replacing the existing data
  • Changing the column name
  • Adding a new column
  • Removing a column
  • Adding a row
  • Deleting a row

Re-importing a file into a Lookup Table

If any changes have been made to your file since the data was imported into a Lookup table you can re-import the data into the Lookup table by:

  1. Select the Lookup Tables tab with the Creative Overview.
  2. Select the relevant Lookup table and either double click on it, or click the Edit button to open.
  3. Click Import Data.
  4. Click Browse to search for the updated file.
  5. Click Next.

As the data has been imported before the Source Columns and Import to Columns will be mapped. To amend the mappings click on the drop-down arrow for the mapping you wish to amend in the Import to Column column.

The source column data shows all the columns read from the selected file. The Import to Column shows the mapping drop-down which shows you a list of the existing columns from the Look-up table being edited.

  1. Check the Erase and replace current table data check box to make the amendments to the existing set of data. Note: if you have just added data to the file you will not need to check this check box.
  2. Click Done.

Changing the Column Name

To change the column name:

  1. Click the drop-down arrow on the column name.
  2. Select Update Name.
  3. Enter the new column name and click OK.

Adding a New Column

To add a new column:

  • Click the New Column button.

Removing a Column

To remove a column:

  1. Clicking the drop-down arrow on the column name.
  2. Select Remove Column.
  3. Select Yes.

Adding a Row

To add a row:

  • Click the button.

Deleting a Row

To delete a row:

  • Select the row and click the button.
Note: A Lookup table must have two columns - a key column, and one additional column.
     
© Alterian. All Rights Reserved. | Privacy Policy | Legal Notice