Transformation Management

Add Transformation to Model Canvas

Add a completed and published transformation as a Table by dragging the Data view onto the Model canvas or selecting the Add button on the data view row.

Calculated Columns and Aggregated Measures are included in the parent table and are available as long as the parent table remains on the canvas.

Remove Data View from Model Canvas

Remove the Data View from the Model Canvas by selecting the Data View Menu, opening More Options and selecting Remove Table.

Delete Transformation

Deleting the transformation is done within the transformation editing canvas by selecting Delete Column, or Delete Data View on the right panel within the transformation.

A confirmation modal will display listing potentially impacted collections which use the transformation.

Note: Models which are used in collections cannot be deleted, and transformations used in collections are similarly linked.

Naming Transformations

The transformation name is the value provided to the Transformation Output. An automatically generated name will be provided upon connection to the Output tile and the Output Tile will switch from Incomplete (red) to Valid (black) once it is properly connected.

Input the desired Transformation Name on the right panel of the Output.

A valid set of transformation step(s) and Input must be connected to the Output to be able to input a name value on the right panel.

Publishing Transformations

Publishing a transformation makes it accessible on the model canvas and confirms there are no data transformation errors.

When transformations are edited and updated, they must be republished to make the latest revision available in the model.

Publishing a transformation also updates the model, requiring every inheriting collection be republished to push the new model configuration to the embedded collection.

To publish a collection open the collection and select the publish button in the top right.

When editing a collection in Verb as an admin, the modified/draft model is used to display data. Therefore the latest version of the transformation and model will be visible when reviewing collections after updates have been made to transformations and models. This efforts the opportunity to review the changes, prior to publishing the collection which would make the changes live for users.