You can change how your transformation configuration displays with blueprint view. You can also view more details about the transform sequence.
Blueprint view
When you open a transformation view, by default, the data displays in grid view. You can change the display to blueprint view, which shows details of the transformation view configuration. Blueprint view doesn't include a sample of the transformed data.
The blueprint view displays a table with these column properties:
- Column name
- Type (data type)
- Source
- Decorations: These icons can display:
- Sigma icon : Displays if the column has aggregations applied (includes all aggregation options except Group by).
- Aggregate icon : Displays if the column has Group by aggregation applied.
- Formula icon : Displays if a formula is applied to a column.
- Detail filter : Displays if a detail filter is applied to a column.
- Aggregate filter : Displays if an aggregate filter is applied to a column.
Change to blueprint view
To change the transformation view display to blueprint view:
- Select Data Orchestrator from the top-left navigation menu.
- Choose a dataspace from the list.
- Select Transformation views from the left-side panel.
- Open a transformation view from the list.
- Select Blueprint at the upper right of the page.
Transform sequence
When you open a transformation view, you can select the expand icon in the left sidebar to view the transform sequence.
The transform sequence displays details about the operations that'll be applied by your transformation view, such as:
- Primary dataset
- Formula
- Join
- Union
- Detail filter
- Aggregate
- Aggregate filter
Note: Table-based data displayed in Data Orchestrator isn't displayed in any order. This is standard behavior in a table based system. You can apply a specific sort order when you preview the transformation view. Note that if you change the sort order in the preview, you can't save the updated preview. The preview resets the next time you return to it.