Configuring the Data Iterator node
- Select the Data Iterator start node. On the General tab, specify this information:
- Configuration name
-
Select the configuration to use for this activity. To use an existing configuration, select a name from the list. If you leave the field blank, the default configuration is used.
- Input method
-
Select File if the input data is read from a file or Data if it is from a variable.
- Input file/Input data
-
If the input method is File, this field specifies the file name to read.
If the input method is Data, this field must contain a reference to a ProcessFlow variable, for example, <!myVariable>).
- Parse by
-
Specify the method by which the data stream is parsed. These are the available options:
-
Line to read the data by line.
Lines are terminated by a line feed ('\n'), a carriage return ('\r'), or a carriage return followed immediately by a linefeed.
-
Delimiter String to split the data by a specified delimiter string, for example a comma.
-
Length to read a specified number of characters at a time.
-
- Starting position to read
-
A position in the data stream where the read begins. The default is zero, which means to start at the beginning of the file or variable.
- Maximum read iterations
-
The maximum number of read iterations to perform on the file. Leave this field blank or specify 0 for unlimited iterations.
- Bytes to read per iteration
-
For the Length parse method only. This field defines the number of characters to read at a time. The activity reads the next n characters or to the end of the input stream.
- Delimiter string
-
For the Delimiter String parse method only. This field defines the delimiter string used to split the input stream. The activity reads up to the next instance of the specified delimiter string or to the end of the input stream.
- Ignore trailing delimiter
-
For the Line and Delimiter String parse methods. This field specifies whether to ignore any trailing delimiter at the end of the stream. If the check box is selected (True) and there is a delimiter immediately before the end of the input stream, the delimiter is ignored. If the check box is cleared (False) and there is a delimiter immediately before the end of the input stream, the delimiter is interpreted as indicating an empty record at the end.
- Accumulate output variables
-
Specifies whether records are output into separate variables as they are parsed. If the check box is selected (True), each record is saved in the activity variable activityName_outputDataN, where activityName is the name of the activity and N is the record number.
- On the On Error tab, specify this information:
- What should happen on an error?
-
Select from the available options.
- Notify
-
Select this check box to send a notification when an error occurs. If this option is selected, you must fill out the notification details.
- Custom log entry
-
Select this check box to have a custom log entry in addition to the system-generated log entry.
- Select the Data Iterator end node. On the Break Condition tab, specify any valid true or false conditions that you must satisfy to end the iteration.
Note:
If a variable is used as part of the condition, you must remove the surrounding brackets ("<!" and ">").