Result Step

The Result step exports data from the preparation flow so it can be viewed in a Process. It is the flow's output: the platform generates a result table that can be queried and, optionally, an export file in the Process View screen. The Result step is located in the Output category of the toolbar.

How to configure

In this step, there are two mandatory fields and a series of fields that describe and format the output columns.

• Name: specifies the name of the result table and file.

• Code: specifies the unique identification code for the result table.

• Enable key fields for unique reference: when enabled, select the result's key field(s). Key fields uniquely identify rows, allowing you to track data throughout the process (e.g., via comments). Prefer transaction identifiers and avoid fields like value, which can change when data is updated.

• Column Status: indicates whether the column is Valid, Invalid, or Inconsistent. It becomes Invalid when the column is deleted in the input step connected to the Result, in which case the platform allows you to delete it. It becomes Inconsistent when the column's data type is changed in the input step, in which case you must adjust the data type to make it consistent.

• Column Order: shows the order in which the columns will be displayed in the output.

• Column Name: shows all columns from the input step. The values in this column are not editable.

• Data Type: displays the input column's data type, which can be Alphanumeric, Numeric, or Date. The values in this column are not editable.

• Formatting: allows you to adjust the decimal places for Numeric fields. Whenever there is such a field, an icon appears; clicking it provides access to formatting options.

Within formatting, you will find:

• Limit Decimal Places: select this field and enter the number of decimal places to display for all fields in the column, from 1 to 8 places.

• Apply formatting to other numeric columns: select which other columns will receive the same formatting.

Download result data

You can download the data present in the Result. Select the step and click the Download button in the Data Sample window. The file is downloaded in XLSX format.