Skip to content

Split Field

The Split Field component lets you 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, for example, 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 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