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
✅	❌	✅	✅	✅