Splits data fields into multiple components. For example, it can divide a comma-separated value (CSV) string into its constituent values, facilitating further individual data processing.
Functionality
The Field Split node can be used to:
- Extract a value separated by delimiters and assign it to a configured JSON key.
- Optionally create a dynamic JSON key from an extracted value and assign the value from the first point.
Outputs
Creates up to 2 JSON keys to hold the value extracted from the list in the Field Variable Name.
How to Use
Implementation
In the Rayven Workflow Builder:
- Select Functions.
- Drag the Field Split node to the canvas.
- Provide an input to the Field Split node by connecting it to another node.
- Double click on the Field Split node to open the configuration window.
Configuration
|
Section: General |
||
|
This section contains basic configuration elements required for any Field Split implementation. |
||
|
Field |
Requirement |
Comments |
|
Node Name |
Mandatory |
Enter a name for this node. This provides a handle to which you and others can refer, so it should be simple but meaningful and explain the node’s purpose. |
|
Section: Split Out Field Variable Value |
||
|
This section contains the configuration required to split the value within a string contained in the JSON payload by the specified delimiters. |
||
|
Field |
Requirement |
Comments |
|
Field Variable Name |
Mandatory |
Enter the JSON key that holds the string containing a list of values separated by a delimiter character. |
|
Field Delimiter Character |
Mandatory |
Enter the delimiter character that is used to separate values in the string. |
|
Index |
Mandatory |
Enter the index position of the value of interest. Note that indexes start from 0. |
|
Output Field Name |
Mandatory |
Enter the new JSON key that will hold the specified value. |
|
Section: Split Out Field Variable Name |
||
|
This optional section contains the configuration required to split the value within a string contained in the JSON payload by the specified delimiters to be used as a new JSON key. |
||
|
Field |
Requirement |
Comments |
|
Field Variable Name |
Mandatory (if this section is used) |
Enter the JSON key that holds the string containing a list of values separated by a delimiter character. |
|
Field Delimiter Character |
Mandatory (if this section is used) |
Enter the delimiter character that is used to separate values in the string. |
|
Index |
Mandatory (if this section is used) |
Enter the index position of the value of interest. Note that indexes start from 0. This value will be used to create a new JSON key to hold the value extracted from the Split Out Field Variable Value section |