Advanced value table settings

This guide explains how to use the advanced settings for value tables.

Accessing value table settings

To access the advanced settings for a value table, follow these steps:

Go to the Transformations page.
Under the page heading, click Value Tables.
Click the chosen value table.

As a result, you can begin to configure the value table settings.

Editing value table entries

To edit existing entries in the value table, follow these steps:

Select the value table with the entries to edit.
In the secondary menu, click Edit Value Table Entries.
Find the entries to edit and make the changes.
Click Save.

To add new entries to a value table, follow these steps:

Select the value table with the entries to edit.
In the secondary menu, click Edit Value Table Entries.
In the top right corner, click the Add Entry button.
In Value, enter the target value to add to the value table.
Click Save.

As a result, a new entry is added to the value table.

Exporting value tables

Export value tables to create other value tables.

To export a value table to a CSV file, follow these steps:

Go to the Transformations page.
Under the page heading, click Value Tables.
Select the value table to export as a CSV file.
In the secondary menu, click Export to CSV.

As a result, a CSV file containing the value table data will start downloading.

Importing value tables

Value tables can be created by importing CSV files that contain the relevant values or by using a transformation script. For more information on creating a value table from a transformation script, see Automatically populate a value table.

Prerequisites

Before you import a CSV file to populate a value table, complete the following:

Create a value table with no entries.
Ensure the CSV file to be imported is UTF-8 encoded.
(Optional) Export data from another value table to be imported into the empty value table.

Procedure

To import a value table from a CSV file, follow these steps:

Go to the Transformations page.
Under the page heading, click Value Tables.
Select the empty value table to import the CSV file into.
In the secondary menu, click Import from CSV.
In Source, click Choose File and select the CSV file to import.
(Optional) In Delimiter, select the character to separate the data in the CSV file.
(Optional) Select the Has header checkbox if the CSV file contains a header row.
Click Upload.

Deleting entries from a value table

To delete an entry from a value table, follow these steps:

Go to the Transformations page.
Under the page heading, click Value Tables.
Select the value table with the entries to delete.
In the secondary menu, click Configuration.
In Value Table Entries section of the page, select the checkbox of the entry or entries to delete.
Click Save.

As a result, the selected table entries are deleted.

Deleting value table entries that are linked to a mapping table may remove values from the table. Check the affected mapping tables and update any empty values accordingly.

Deleting a value table

To delete a value table, follow these steps:

Go to the Transformations page.
Under the page heading, click Value Tables.
Select the value table to delete.
In the secondary menu, click Configuration.
At the bottom of the page, click Delete.
In the Are you sure? page, to confirm the deletion of the table, click Yes, I'm Sure.
Click Save.

As a result, the table is deleted.

Deleting a value table that is linked to a mapping table may remove values from the table. Check the affected mapping tables and update any empty values accordingly.