Spectre Flow Rotate Process Object

The Spectre Flow Rotate Process object allows you to reorient your data before building the output.

The Rotate Process object has three sections in the properties panel where you set attributes. Depending on the Rotate Mode value (Manual Grid or Automatic Range), the properties panel has a different configuration.

The Manual Grid rotate type view:

The Automatic Range rotate type view:

Spectre Flow Rotate Process Node Properties Auto Range

You set attributes for the Rotate Process object in the Closedobject attributes section.

Attribute Description
Rotate Mode

Determines how the rotate columns are specified:

  • Automatic Range—Values are automatically combined based on a selected range of From and To columns.

  • Manual Grid—Values are manually set. Multiple value columns are allowed in this mode.

For information about the flow script tag, see auto-rows.
Dimension Column Specifies the name of the new dimension column. This column must be unique (it cannot also be the same as the Value Column). For information about the flow script tag, see dimension-column.
Dimension Sorting Determines how the output columns are sorted. For information about the flow script tag, see no-alternate-sort
Value Column Specifies the name of the new value column. This value is only available when the Rotate Mode value is Automatic Range. When the Rotate Mode is Manual Grid, multiple value columns can be specified in the column grid. This column must be unique (it cannot be the same as the Dimension Column). For information about the flow script tag, see value-column

Each object has an area where you can enter comments. It is DI best practice to enter a note for every object in a Spectre Flow script.

Every Spectre Flow node comment area is Markdown-enabled. For more information, see Workbench Markdown Editor.

The Rotate Process object Closedcolumn grid section is where From and To ranges are set for the automatic rotation.

Attribute Description
From Identifies the column that starts the column range.
To Identifies the column that ends the column range.
Exclude Excludes the selected column from the rotation.
Name Displays the name of each input column. This attribute is read-only.
Type Displays the type of each input column. This attribute is read-only.
Source Object

Displays the name of the source object for the column. This attribute is read-only. Double-click the Source Object value for a column to change focus to that object.

The Rotate Process object Closedcolumn grid section is where value columns are added and defined.

To rotate columns with the manual grid:

  1. Name a dimension column in the Dimension Column field in the object attributes.

    The dimension column appears in the column grid.

  2. Right-click on the column grid and select Add Column from the context menu.

    A value column is created.

  3. Click the pulldown menu in the value column.

  4. Select the columns to rotate from the pulldown menu.

Repeat this process for as many value columns are needed.

To access column properties, select a column from the Column List. The following attributes are common column attributes. For a list of all column attributes, including attributes specific to certain data types, see Spectre Flow Column Tags.

Attribute Description
Name Read only attribute displaying the name of the column.
Type Specifies the data type of the column. Available data types are string, integer, double, fixed100, date, datetime, period, and boolean.
Sort By Defines another column to sort by when this column is sorted. For example, setting Month Number as the Sort By column for Month sorts months by their number instead of their alphabetical order (1 (Jan), 2 (Feb), 3 (Mar), etc.).
Label Defines a display name for a column. This name is displayed in ProDiver and DivePort, while calculations and other technical processes use the value in the Name attribute.
Required Dimension

Sets a column to behave like a classic Info Field. In ProDiver, the info field is available as a column that you can add to other columns displayed in a dive. For example, to see the Address column requires that the Customer column is available.

  1. Select the column you want to define as an Info Field.

  2. Select Required Dimension in the Properties pane.

  3. Locate and select the core dimension from the list.

    The first column is only available when the second column is displayed in the client.
Suggested Dimension

Allows you to promote or demote a column.

  • Set to True to promote a numeric column type to become a diveable dimension and have it appear in the ProDiver console.

  • Set to False to demote a column from classification as a dimension so it does not appear in the ProDiver console.

  • When set to False, the new dimension does not appear in the console (which requires dimcount processing), but it can be promoted to a dimension for diving—equivalent to the concept of a dynamic dimension for a classic model.

  • Using Required Dimension on a column effectively sets Suggested Dimension to False.

Comment Defines a comment that describes this column.