Home
Data Quality
Assure reliability, consistency, and accuracy data from different sources to deliver value to employees and customers.
Data Quality pipelines
Pipelines define and apply transforms to data loaded by a dataset.
Reference
This section contains reference information for pipeline pages in Precisely DQ.
Data Quality Transforms
Pipeline transform settings are configured to add transformation steps in a pipeline. This reference describes the purpose of each transform and its settings that define a transformation step in a pipeline.
Split Column
Splits a column into two new columns.

Welcome
The Precisely Data Integrity Suite is designed to deliver trusted data with accuracy, consistency, and context – built on the core capabilities of data integration, data quality, data governance, location intelligence, and data enrichment.
Data Integration
Replicate data from mainframe, IBM i, and relational databases to cloud analytics platforms.
Data Observability
Proactively monitor and manage the health of your data. Receive actionable insights through alerts that drive business decisions.
Data Governance
Manage data policy and processes with greater insight into your data's meaning, lineage, and impact.
Data Quality
Assure reliability, consistency, and accuracy data from different sources to deliver value to employees and customers.
- Data Quality Catalogs
  The Data Integrity Suite Data Catalog lets users discover and understand connected data sources.
- Data Quality datasets
  A dataset defines a data source and characterizes data to be loaded and transformed by pipelines.
- Data Quality pipelines
  Pipelines define and apply transforms to data loaded by a dataset.
  - About Data Quality pipelines
  - Using Data Quality pipelines
  - How to
  - Reference
    This section contains reference information for pipeline pages in Precisely DQ.
    - Pipelines
      The table on this page lists pipelines. On this page you can create a new pipeline or edit, delete, or rename any existing pipeline.
    - Pipeline settings
      The pipeline settings page allows you to view and edit transformation steps in a pipeline.
    - Add Step
      Choose a transformation in this dialog box to add it as a step in a pipeline.
    - Data Quality Transforms
      Pipeline transform settings are configured to add transformation steps in a pipeline. This reference describes the purpose of each transform and its settings that define a transformation step in a pipeline.
      - Case Field
        Converts strings in a field into upper, lower, or title case.
      - Copy Column
        Copies a column to one or more new columns.
      - Execute Formula
        Performs operations on values and inserts the result in a new column.
      - Filter Column
        Removes selected columns from a table.
      - Get Substring
        Returns the substring from the start position to the end position. Index of the first character is 1.
      - Pad String
        Pads the beginning or end of field content with a string to a specified length. The Pad field transform does not change the value of the original string.
      - Parse Name
        This transformation parses personal and business names into their constituent parts, such as given name, surname, and titles and qualifiers.
      - Rename Column
        Renames a column in a pipeline.
      - Replace Between
        Replaces a substring between two specified characters.
      - Replace By Position
        Replaces the substring from the start position to the end position.
      - Replace Consecutive Spaces
        Replaces all instances of two or more consecutive spaces in a string field value with a single space.
      - Filter Row
        The row filter evaluates whether to include rows depending on a logical expression that evaluates to either true or false.
      - Search and Replace
        Use Search and Replace in a pipeline to search for strings in columns and replace them with a different string.
      - Split Column
        Splits a column into two new columns.
      - Standardize Date
        If a data column contains dates in different formats, use the Standardize Date transformation to convert values in all records to a single format.
      - Standardize Field
        The Standardize Field transformation applies one or more standard conversions to semantically typed fields.
      - Trim String
        Removes specified characters from the start or end of a string.
      - Verify Address
        The Verify Address transform parses, matches, and formats address data against reference postal data. A confidence level is assigned to each verified record.
- Data Quality jobs
- Data Connections
  Connecting to data is the first step in processing, analyzing, and storing information.
Administration
Manage your subscription, your users and their roles, and other system tasks.

Split Column

Splits a column into two new columns.

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

Step name

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

Column

Specifies a column 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 a column name. Alternatively, click a column heading in the inspection table to select the corresponding column name in this box. You can use the search box to filter and select columns in the list.

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.

Right split name

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

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.