tFlowToIterate

Use the default (key, value) in global variables

When selected, the system uses the default value of the global variable in the current Job.

Customize

• key: Type in a name for the new global variable. Press Ctrl+Space to access all available variables either global or user-defined.

• value: Click in the cell to access a list of the columns attached to the defined global variable.

Global Variables

ERROR_MESSAGE: the error message generated by the component when an error occurs. This is an After variable and it returns a string. This variable functions only if the Die on error check box is cleared, if the component has this check box.

NB_LINE: the number of rows processed. This is an After variable and it returns an integer.

CURRENT_ITERATION: the sequence number of the current iteration. This is a Flow variable and it returns an integer.

A Flow variable functions during the execution of a component while an After variable functions after the execution of the component.

To fill up a field or expression with a variable, press Ctrl+Space to access the variable list and choose the variable to use from it.

For more information about variables, see Using contexts and variables.

Usage rule

You cannot use this component as a start component. tFlowToIterate requires an output component.

Connections

Outgoing links (from this component to another):

Row: Iterate

Trigger: Run if; On Component Ok; On Component Error.

Incoming links (from one component to this one):

Row: Main;

For further information regarding connections, see Using connections in a Job.