Split field

Data Integrity Suite
Product
Spatial_Analytics
Data_Integration
Data_Enrichment
Data_Governance
Precisely_Data_Integrity_Suite
geo_addressing_1
Data_Observability
Data_Quality
dis_core_foundation
Services
Spatial Analytics
Data Integration
Data Enrichment
Data Governance
Geo Addressing
Data Observability
Data Quality
Core Foundation
ft:title
Data Integrity Suite
ft:locale
en-US
PublicationType
pt_product_guide
copyrightfirst
2000
copyrightlast
2025
Type: General step

Splits a column into two new columns.

This step splits column values on the first or last instance of a delimiter character into two new columns. The two new columns are appended after the last existing column in the table. The column that was split by the transformation remains in the table in its original position. Semantic analysis is applied to detect the semantic types of the new columns.

CAUTION:
Do not specify the name of an existing field in a cataloged dataset for the left or right split name unless you want to overwrite values already in the existing field.

Step name Defines the name for a step. Provide a meaningful name so that anyone who edits steps in a pipeline will be able to identify the purpose of a step.

Columns Specifies columns to transform. Click to view the list of column names. Column names listed here correspond to the column names in the dataset inspection table. Click in the drop-down list to select or clear check boxes next to column names. Alternatively, click column headings in the inspection table to select or clear check boxes next to the corresponding column names in this box. To add a column to the selection, you must press the Ctrl key when you click a column heading.

Select or enter delimiter Specifies the character on which to split column values into two columns. The character itself is not included in either of the two new column values. Choose one of the following characters in the list box.

  • Comma (,)
  • Period (.)
  • Pipe (|)
  • Semicolon (;)
  • Space ( )
  • Tab

Split at Specifies whether to split on the first (left-most) or the last (right-most) instance of the delimiter character in the column.

  • Left-most delimiter—Split the column on the first instance of the delimiter character.
  • Right-most delimiter—Split the column on the last instance of the delimiter character.

Left split name Specifies the name of the first new column that results from the split.

CAUTION:
If the left split name is the same as the name of an existing field in the cataloged dataset, values in the left split column may overwrite values already in the dataset field.

Right split name Specifies the name of the second new column that results from the split.

CAUTION:
If the right split name is the same as the name of an existing field in the cataloged dataset, values in the right split column may overwrite values already in the dataset field.

Save Click this button to save the configured transform and append it to the Transformation Steps.

Preview Click this button to preview the result of the configured transform.

Cancel Click this button to close the transform configuration without saving your settings.