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 Structural that the columns are related to each other, and that Structural 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.
Generating data using links
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, use the Link to dropdown to link the columns.
The dropdown contains the columns that have the same generator applied. You can link to any or all of those columns.
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:
The below image shows the results when you apply the Address 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, Chicago is not in Arizona and Phoenix is not in New York.
The next image shows the results when you apply the Address generator to and link the city and state columns. This preserves the data hierarchy and ensures that the city and state combinations are valid.
Generators that support linking
The following generators can be linked:
Last updated
Was this helpful?