Split Field
The Split Field component lets users split up the value of a column in an input flow according to a specified delimiter. The delimiter can be any valid character or sequence of characters.
Properties
Name
= string
A human-readable name for the component.
Input Column
= drop-down
The input field to split.
Delimiter
= string
The delimiter to split on.
Unlike when loading text files, the delimiter is not limited to a single character.
Output Columns
= column editor
- Position: The Position is the index number of the split field to extract. This index starts at 1, not 0.
- Output Column: The new field name to hold the extracted data. All target field names are text, but if you are certain they represent, e.g., a Date or Number type, you can use the Convert Type component to cast the data type appropriately.
Include Input Column
= drop-down
Choose whether or not to keep the original field in the output. If you have extracted all the parts of the field, you may not need the original anymore.
Snowflake | Delta Lake on Databricks | Amazon Redshift | Google BigQuery | Azure Synapse Analytics |
---|---|---|---|---|
✅ | ❌ | ✅ | ✅ | ✅ |