Translation tables

Translation tables allow you to translate field values, enrich and validate data in all documents sent or received.

With translation tables, you can:

Abbreviate specific values.
Prevent fields being incorrectly extracted due to punctuation.
Ensure consistent output formatting.
Replace certain field values with spaces in the output.

In Compliance Network, translation tables are structures that can be used by your organization's plugins in the mapping process. These structures provide lookup and reference tables, which allow for value translation and data enrichment.

Note: Except for Find a translation table, all articles here are for Workspace Admins only.

Find a translation table

Go to Network on the navigation menu.
Search for a company name using their name or tax ID to find out which network it belongs to. Then, click to open the matching network.
Select the company under Partner Name.
Click the Settings icon and select Translation tables:
Select a table in the table selection menu.

Create a translation table

Go to Network on the navigation menu.
Search for a company name using their name or tax ID to find out which network it belongs to. Then, click to open the matching network.
Select the company under Partner Name.
Click the Settings icon and select Translation tables.
Click New translation table.

Add the translation table's structure

Enter the name and description of the table.
To have more than the default number of columns, click Add column.
Click a column name to edit or delete it.
While editing a column, you have these options:
- Column Name: Change it to an expression describing the values from that column.
- Regular expression (required): Enter a custom Regular expression (regex) or select one of the options from the Or select default menu. This will restrict the type of data that can be entered in the table for the items in this column.
- Is required: If you have more than two columns (default), you can select or deselect this box.
- Delete: If you have more than two columns (default), you can click this button to delete it.
Click outside the More options pop-up to edit another column.
After customizing the table structure, click Next: Enter Data.

Enter data in the translation table

Click Add row.
Fill out each cell according to the data type defined while creating the table's structure.
Important: When filling out each cell on your translation table, each column will only accept the Regular expression chosen while creating the table structure. For example, if you created a Date column and selected the date format as MM/DD/YYYY, the cells in this column will only accept  numbers in that format.
Select Save or Delete for each row, as needed.
After saving each row, click Done.

Edit a translation table

Go to Network on the navigation menu.
Search for a company name using their name or tax ID to find out which network it belongs to. Then, click to open the matching network.
Select the company under Partner Name.
Click the Settings icon and select Translation tables.
Select a table in the table selection menu.
Click Edit.
After saving any changes on each row or deleting one or more rows, click Done.

Delete a translation table

Go to Network on the navigation menu.
Search for a company name using their name or tax ID to find out which network it belongs to. Then, click to open the matching network.
Select the company under Partner Name.
Click the Settings icon and select Translation tables.
Select a table in the table selection menu.
If the translation table's cells have data, click Edit.
Select Delete on each row. Then, click Delete to confirm.
Click Done to finish editing the table.
Click the trash icon to delete.
Select Delete to confirm.

Sovos Docs