Iterator - iterate using delimeter
Search form
Description - Delimited value iteration produces one XML row document per row in the delimited value (e.g. comma delimited) input
Runtime Class - com.ibi.agents.XDIterDelVal
Parameter Groups
Parameter Type Description * Header: boolean Determines whether the first row is a header row. If not (false), then the first row contains data and generated names are used for the elements. If set to true, then the first row holds the names, and the data starts at the second row.
* Delimiter: string What delimiter is to be used? Select, enter one character or a single hex value as \xvv where vv is a hex value.
Select from one of the following options:
- comma - Uses a comma to delimit fields
- tab - Uses a tab (0x09) to delimit fields
* - denotes required
Parameter Type Description * Root Element: string Name of the XML outer tag which wraps the transient document.
Trim values: boolean Determines whether all values should be trimmed.
Quotes: boolean Determines whether surrounding quotes should be eliminated.
Empty Elements: boolean Determines whether empty elements at the right should be eliminated.
* - denotes required
Parameter Type Description * Document: string Final document emitted is a status document, the original document, the result of the last iteration or an accumulation. Accumulations are memory intensive.
Select from one of the following options:
- Status Document {status} - Status document
- Original Document {original} - Document when originally passing into this service
- Transient Document {transient} - Result of the last iteration
- Loop Accumulation {accumin} - Accumulation of the input loop elements sent from the flow back into the iterator at each pass. The loop may have modified the document passed to the accumulation. For XML, the root name will be the node name. Use of accumulation can result in significant use of memory.
- Iterated Accumulation {accumout} - Accumulation of the output iterated elements of each pass; these are the documents that the loop services receive from the iterator. For XML, the root name will be the node name. Use of accumulation can result in significant use of memory.
* - denotes required
Output Events
Runtime Class - com.ibi.agents.XDIterDelVal
Parameter Groups
Parameter Type Description * Header: boolean Determines whether the first row is a header row. If not (false), then the first row contains data and generated names are used for the elements. If set to true, then the first row holds the names, and the data starts at the second row.
* Delimiter: string What delimiter is to be used? Select, enter one character or a single hex value as \xvv where vv is a hex value.
Select from one of the following options:
- comma - Uses a comma to delimit fields
- tab - Uses a tab (0x09) to delimit fields
* - denotes required
Parameter Type Description * Root Element: string Name of the XML outer tag which wraps the transient document.
Trim values: boolean Determines whether all values should be trimmed.
Quotes: boolean Determines whether surrounding quotes should be eliminated.
Empty Elements: boolean Determines whether empty elements at the right should be eliminated.
* - denotes required
Parameter Type Description * Document: string Final document emitted is a status document, the original document, the result of the last iteration or an accumulation. Accumulations are memory intensive.
Select from one of the following options:
- Status Document {status} - Status document
- Original Document {original} - Document when originally passing into this service
- Transient Document {transient} - Result of the last iteration
- Loop Accumulation {accumin} - Accumulation of the input loop elements sent from the flow back into the iterator at each pass. The loop may have modified the document passed to the accumulation. For XML, the root name will be the node name. Use of accumulation can result in significant use of memory.
- Iterated Accumulation {accumout} - Accumulation of the output iterated elements of each pass; these are the documents that the loop services receive from the iterator. For XML, the root name will be the node name. Use of accumulation can result in significant use of memory.
* - denotes required
Output Events
Parameter Groups
| Parameter | Type | Description | |
|---|---|---|---|
| * | Header: | boolean | Determines whether the first row is a header row. If not (false), then the first row contains data and generated names are used for the elements. If set to true, then the first row holds the names, and the data starts at the second row. | * | Delimiter: | string | What delimiter is to be used? Select, enter one character or a single hex value as \xvv where vv is a hex value.
Select from one of the following options:
|
* - denotes required
| Parameter | Type | Description | |
|---|---|---|---|
| * | Root Element: | string | Name of the XML outer tag which wraps the transient document. | Trim values: | boolean | Determines whether all values should be trimmed. | Quotes: | boolean | Determines whether surrounding quotes should be eliminated. | Empty Elements: | boolean | Determines whether empty elements at the right should be eliminated. |
* - denotes required
| Parameter | Type | Description | |
|---|---|---|---|
| * | Document: | string | Final document emitted is a status document, the original document, the result of the last iteration or an accumulation. Accumulations are memory intensive.
Select from one of the following options:
|
* - denotes required
Output Events
| Name | Description |
|---|---|
| OnParseError | Could not parse a document. |