WHAT IS A VALUE TABLE?
In a Mapping Table you can translate values by providing a match dimension value plus it's translated version. Sometimes it can be helpful to have a pre-defined selection of values to translate to in a drop-down list instead of manually entering the value. This prevents spelling errors and makes manually populating mapping tables much faster and less error-prone.
A value table stores these pre-defined values. The most common usage of a value table is the pre-defined selection of Insights tenants. However, you can also create a value table for any other type of value either by creating a static value table or by dynamically tracking all available values within a certain column of a datastream.
This can be helpful when you want to translate multiple values from a certain column to a unified value in a mapping table.
From multiple datasources, you get multiple names for the same car model. You can use a mapping table to standardise these values. Instead of typing the complete standardised name for each mapping table entry, you can simply select the new car model from the drop-down list. The value table provides these standardised car model names.
STEP 1 (a): CREATE STATIC VALUE TABLE
- Go to Value Tables and Click Add+
- Populate Organization and Name, leave Sync Provider blank
- Click Add another Value Table Entry and insert value that you'd like to be available in the drop-down list of the mapping table
- OR click Import from CSV and upload a file that contains 1 column with the values you'd like to have available in the drop-down list
- Save the value table once you have added all required entries
STEP 1 (b): CREATE DYNAMIC VALUE TABLE
- Open the datastream that contains the values you'd like to make available in the Value Table or set up a new stream if required
- On the datastream dashboard, under Tracked Columns click on the column containing your standardised values
- Tick both boxes, Track values and Confirmed type, save
- Fetch data. All unique values within the fetched period are added to the Value Table
- Under menu item Value Tables a newly created table, that's named by the column tracked, is now available. It contains all unique values appearing in the tracked column
STEP 2: POPULATE MAPPING TABLE BY USING VALUES OF VALUE TABLE
- Go to the mapping table and select the created Value Table under Default Value Table
- When populating the mapping table click on the link icon of the right hand column to open the list of available values