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.
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|