Skip to main content

Start Loop

Description:

Start Loop defines the beginning of a repeating block within a workflow. It executes the steps between itself and its paired Continue Loop step multiple times for each input row, either for a fixed number of iterations or until a dynamic condition is met. The loop runs single-threaded — other input rows wait until the current row finishes all its iterations. You can define additional fields that persist across iterations and remain available after the loop ends, while any other fields created inside the loop are discarded after each iteration. Start Loop produces two output hops (true and false), letting you route rows that continue looping separately from rows that exit the loop.

Configurations:

Start Loop step configuration dialog
Field NameDescription
Step NameName of the step. This name has to be unique in a single workflow.
Loop NameA Loop Name generated automatically.
Conditional Loop?Enable check box if you want to loop based on a condition. If enabled Iterator name below is disabled.
Iterator NameThis field is enabled Conditional Loop above is not checked. Provide an iterator name.
Number of iterationsProvide an integer value for number of iterations for each row.
Table: Additional Fields1This table is used to create user defined additional fields.

Additional fields are added as columns to the row. They are permanent and visible even after the loop is over.

Note: Any fields created within a loop are not permanently available after loop execution. Only Additional fields specified in Loop Start are available even after loop execution.

NameProvide names of all additional fields you want to define.
TypeSelect a data type for the additional field.
FormatSelect a format for the data Type selected above.
Default valueProvide a default value for the additional field.
Set empty string?Select Y or N.

If default value is not provided set ‘Set empty string?’ to Y. This sets a null value as an empty string.

Block: ConditionsConditions Block is a set of five fields. These fields can be populated with Previous field, Addition fields or Static values. Click the field to populate a value as a toggle or from a popup that comes up.

The first field specifies a toggle for a condition. Leave it default to blank or click once to toggle it to NOT.

The second is the field to compare. The third field is an operator

The fourth field is the field to be compared against or alternately specify a static value in the sixth field to be compared against.

Click on the small rectangular icon on the right hand side of the block to add a condition. You can Add a condition with the following operators: OR, AND, OR NOT, AND NOT, XOR. Multiple condition list by icon on right side.

Right click on a condition to get a pop-up menu with the following options: Edit condition, Delete condition, Add sub - condition, Move condition to sub-condition (-->), Move condition to parent (<--) and more copy options. These options can be used to create Nested conditions.

Button: Get FieldsIn the Conditions Block above only previous fields are available. Click Get Fields to make Additional fields also available in the conditions block.

Conditions Block Description:

  1. The first field is a Boolean and value can be set to null or NOT. This field acts like a toggle field and changes values upon click. The possible values are null or NOT.
Null condition toggle in the conditions block
  • Null condition
  • NOT condition
NOT condition toggle in the conditions block Condition block with populated values
  1. In the second field User defined Additional fields can be selected.
  2. In this case ‘a’ is selected and is assigned a value 2. It can also be assigned a field value.
Selecting additional field in condition block
  1. Multiple conditions can be added using the Add condition on the right.
Add condition options with AND OR operators
  1. In the snapshot below the first condition has been added and ready to add the second condition. Click on the null condition to populate it.
First condition added with second condition ready to populate
  1. In the third field select operational functions.
Operational functions dropdown in condition block
  1. In the fourth field previous step fields or Additional fields can be set. Values can be set either in the fourth step or in the fifth fields.
Previous step fields selection in condition block
  1. In the fifth and final field provide a static value along with conversion format.
Static value field with conversion format options