User Community Service Desk Downloads

Data Transformation Steps Reference

This reference details all available transformation steps and how to configure them.

Input and output steps

Input steps

Step Description Available for Documentation

Catalog item input

Reads data from the selected catalog item.

  • Standalone plan

  • Embedded plan

  • Transformation catalog item

Learn more

Input

A generic input step that can be used to embed the plan into another or define inputs for transformation rules.

  • Embedded plan

  • Transformation rule

Learn more

Output steps

Step Description Available for Documentation

Database output

Writes transformed data back to the data catalog by overwriting or appending existing items.

  • Standalone plan

  • Embedded plan

Learn more

Output

A generic output step which can be used to embed the plan into another.

  • Transformation rule

  • Embedded plan

Learn more

Data transformation CI

Outputs transformation catalog item (TCI) data flow results. The contents of the output are computed every time an action is run on the TCI.

  • Transformation catalog item (automatically added)

Learn more

Steps available for all transformation types

The following steps work with standalone plans, embedded plans, transformation rules, and transformation catalog items:

Step Description Documentation

Add attributes

Adds new attributes to your data flow using ONE expressions.

Learn more

Condition

Splits the data flow into two streams based on the ONE expression condition.

Learn more

Delete attributes

Deletes selected attributes from your data flow.

Learn more

Transform data

Transforms attribute values using the ONE expression language.

Learn more

Steps for plans and catalog items only

These steps are available for standalone plans, embedded plans, and transformation catalog items (not transformation rules):

Step Description Documentation

Embedded plan

Inserts an existing transformation plan created in ONE.

Learn more

Filter

Filters out all records that don’t pass the ONE expression condition.

Learn more

Group aggregator

Groups and aggregates records to consolidate data.

Learn more

Join

Joins two separate data flows into a single data flow (vertical merge).

Learn more

Split

Splits the data flow into three streams based on the ONE expression condition.

Learn more

Union streams

Merges input formats of two defined inputs into a single output format (horizontal merge).

Learn more

Was this page useful?