Spectre Flow List Input Object

The Spectre Flow List Input object brings raw data into the flow script from within the node.

For a general discussion about list input for Spectre, see About Spectre List Input.

The List Input object has three sections in the properties panel where you set attributes.

Spectre Flow List Input Node Properties

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.

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 List Input object Closedcolumn grid section is where you can add columns and row data.

To add a new column to the column grid:

  1. Right-click on the column grid.

  2. Click Add Column.

  3. A new column is added.

Click on the empty row to add a new value to that cell.