Use a translation table

Once a translation table is built, it can be used in a record or in a standard metric. You can map a field in a record or a dimension in a metric to a translation table. The record field or metric dimension must have values that equate to the IDs in the translation table.

To do this, highlight a field that is already mapped, and in the Property panel, find the Translation Table property. Select the required table from the list.

In cases when a record is based on another document bound with a translation table, this connection is inherited. For example, if a record field is mapped to the translation table, and then another record is built on this record, this field is automatically linked to the translation table. In this case, you can change the translation table via the Property panel.

For other cases, when a metric is based on a record bound with the translation table, to change the inherited connection with the translation table, find the Inherited property in the Property panel and verify that the check box is cleared.

If the translation table does not contain all the possible values for the dimensions for which it is assigned in the metric, you can select Incomplete property for this translation table in the Property panel.

If you map the translation table to the record field, you can select Can be null property for this field, that will allow you to display empty or undefined translation table fields.

Typically, the left join type is used for resolving translation table values in the record's field. But in case the Can be null property is not selected, and the translation table is complete, the inner join type will be used automatically. Learn more about join types New records - join data sources.