About the Split Agent
The Split agent allows you to separate a text field into multiple columns or rows, providing flexibility when working with data that includes delimited values. This agent supports trimming whitespace and keeping or discarding the original column.
Configuration Options
1. Input Field:
Select the column that you want to split. The column will be implicitly converted to a text field if it isn't already.
2. Separator:
Enter the string or character used as a delimiter to split the values in the selected field.
3. Split Direction:
Choose between:
Split to Columns: Splits the values into separate columns.
Split to Rows: Splits the values into separate rows.
4. Trim Whitespace:
Toggle this option to trim whitespace (both left and right) around the separated values.
5. Keep Split Column:
Toggle this option to keep the original unsplit column in the output. If disabled, the original column will be discarded after the split.
Additional Notes
The number of new columns or rows created by the split is equivalent to the number of instances of the separator found in each cell of the input field.
The Split agent supports whitespace characters as delimiters, including:
Tab (
\t)New Line (
\n)Space (
\s)