Data Grid

Description

Data Grid creates a static, in-line tabular dataset directly within a workflow without requiring an external data source. Use this step for testing, demonstrations, or providing small reference datasets — for example, defining a lookup table of status codes or generating sample rows to validate downstream logic. You define the field metadata and data values in the step configuration, making it a quick way to inject known data into any point in a workflow.

Configurations

Field Name	Description
Meta Tab:	On this tab you can specify the field metadata (output specification) of the data
Step name	Name of the step. This name has to be unique in a single workflow.
Name	Provide a name for column in your grid.
Type	Select a data type from a list.
Format	Choose a format from the list.
Length	Specify the length of the field.
Precision	Specify the precision of the output data type.
Currency	Specify the currency symbol to use.
Decimal	Specify the decimal symbol.
Group	Specify the grouping symbol to use.
Set empty string?	Set the field value to null (Y/N)
Secret	Select Y to mark the field as a secret. The step masks the value (displays *******) in downstream steps, previews, and logs. To protect the data, the field is excluded by default when writing to an output file or database. Select N to keep the field value visible. The step displays the actual value in previews and logs and writes it to the output file or database. Notes: - If the Secret setting is changed from Y to N, the field value is cleared. The value must be entered again. - If a secret field is combined with plain text in an upstream step (for example, using a Calculator step to create "Token: " + secretField), the result is treated as a new field and is not protected automatically. Mark the new field as Secret to protect the value.
Data Tab:	This grid contains the data. Everything is entered in String format so make sure you use the correct format masks in the metadata tab.