Links

Linking generators

The linking option for a generator allows multiple columns within the same table to use a single generator.
At a high level, consider using linking when columns share a strong interdependency or correlation.
When you link columns, you tell Tonic that the columns are related to each other, and that Tonic should take this relationship into account when it generates new data.
In a child workspace, if you change the configuration of a linked column, the columns that it is linked to also are marked as having overrides to the parent workspace configuration.
Note that you cannot configure linking as part of a generator preset. You can only configure linking when you configure specific columns.
To link columns, you first assign the same generator to those columns.
After you assign the generator, then on the generator configuration panel for any of the columns, you can link the columns.
Linking two categorical generators

Example using categorical generators

Categorical generators support linking and can be used to preserve hierarchical data. Examples of hierarchical data include:
  • City, State, Zip
  • Job Title, Department
  • Day of Month, Month, Year
To illustrate how linking works, we'll use an example of city and state columns. Here is the original data:
Original city and state data
The below image shows the results when you apply the Categorical generator to city and state columns, but do not link the columns. Because the columns are not linked, the values in each column are shuffled independently. In the output, the city and state combinations are not valid. For example, Phoenix is not in Florida and Baltimore is not in Tennessee.
An unlinked categorical generator applied to city and state columns
The next image shows the results when you apply the Categorical generator to and link the city and state columns. This preserves the data hierarchy and ensures that the city and state combinations are valid.
A linked categorical generator applied to city and state columns

Generators that support linking

The following generators can be linked:
Last modified 4mo ago