Reference: Dataset Stages

Stage Type	Description
Import	The first stage in every pipeline in a derived dataset is an Import stage. An Import stage imports data from a source, and for derived datasets that source is the output of a table or an existing dataset. Workday automatically creates an Import stage when necessary. You can't delete or add an Import stage.
Parse	A Parse stage is a type of stage that enables you to describe the source data in a tabular format. Workday automatically displays the Parse stage when you create a dataset using external data. You can't delete or add a Parse stage.
Manage Fields	A Manage Fields stage is a type of stage that enables you to view field changes, select fields, and edit fields.
Filter	A Filter stage is a type of stage that constrains rows in a dataset based on the filter criteria you define. Add Filter stages to limit the data in the dataset for analysis, such as on a particular region or year. You can add or delete a Filter stage in the middle or at the end of a pipeline.
Group By	A Group By stage is a type of stage that enables you to summarize (aggregate) multiple values in a dataset by specified groups. You can summarize the values using a summarization type, such as MIN, MAX, or SUM. Add Group By stages to get data to the appropriate level that you need to join the data in 1 dataset with another dataset. You can add or delete a Group By stage in the middle or at the end of a pipeline.
Join	A Join stage is a type of stage that combines fields from 2 dataset pipelines based on common values that exist in each pipeline. Add Join stages to view and use related data from different datasets. You can add Join stages to derived datasets only. Derived datasets are the only datasets that can use multiple datasets as their source data. You can add or delete a Join stage anywhere in the Primary Pipeline of the derived dataset.
Union	A Union stage is a type of stage that combines data from similar fields in different datasets into a single field. Add Union stages to: Combine datasets that have similar, but not identical schema. Combine datasets with the same schema but with source data from different locations, such as different SFTP servers. You can add Union stages to derived datasets only. Derived datasets are the only datasets that can use multiple datasets as their source data. You can add or delete a Union stage anywhere in the Primary Pipeline of the derived dataset.
Unpivot	An Unpivot stage is a type of stage that converts fields (columns) to rows. Add an Unpivot stage to consolidate data from 2 or more similar fields into a pair of new fields. You can add Unpivot stages to derived datasets only. You can add or delete an Unpivot stage anywhere in pipelines of the derived dataset.

Import

The first stage in every pipeline in a derived dataset is an Import stage. An Import stage imports data from a source, and for derived datasets that source is the output of a table or an existing dataset. Workday automatically creates an Import stage when necessary.

You can't delete or add an Import stage.

Parse

A Parse stage is a type of stage that enables you to describe the source data in a tabular format. Workday automatically displays the Parse stage when you create a dataset using external data.

You can't delete or add a Parse stage.

Manage Fields

A Manage Fields stage is a type of stage that enables you to view field changes, select fields, and edit fields.

Filter

A Filter stage is a type of stage that constrains rows in a dataset based on the filter criteria you define. Add Filter stages to limit the data in the dataset for analysis, such as on a particular region or year.

You can add or delete a Filter stage in the middle or at the end of a pipeline.

Group By

A Group By stage is a type of stage that enables you to summarize (aggregate) multiple values in a dataset by specified groups. You can summarize the values using a summarization type, such as MIN, MAX, or SUM. Add Group By stages to get data to the appropriate level that you need to join the data in 1 dataset with another dataset.

You can add or delete a Group By stage in the middle or at the end of a pipeline.

Join

A Join stage is a type of stage that combines fields from 2 dataset pipelines based on common values that exist in each pipeline. Add Join stages to view and use related data from different datasets. You can add Join stages to derived datasets only. Derived datasets are the only datasets that can use multiple datasets as their source data.

You can add or delete a Join stage anywhere in the Primary Pipeline of the derived dataset.

Union

A Union stage is a type of stage that combines data from similar fields in different datasets into a single field. Add Union stages to:

Combine datasets that have similar, but not identical schema.

Combine datasets with the same schema but with source data from different locations, such as different SFTP servers.

You can add Union stages to derived datasets only. Derived datasets are the only datasets that can use multiple datasets as their source data.

You can add or delete a Union stage anywhere in the Primary Pipeline of the derived dataset.

Unpivot

An Unpivot stage is a type of stage that converts fields (columns) to rows. Add an Unpivot stage to consolidate data from 2 or more similar fields into a pair of new fields.

You can add Unpivot stages to derived datasets only.

You can add or delete an Unpivot stage anywhere in pipelines of the derived dataset.