Reference: Dataset Stages
Prism Analytics supports these stage types:
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. If you're new to Workday, you don't have access to create or edit base datasets. |
Explode | An Explode stage is a type of stage that converts a multi-instance field into an instance field. Workday takes each instance value in the multi-instance field and creates a new row for each value.
You can add or delete an Explode stage in the middle or at the end of a pipeline. |
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.
You can add or delete a Join stage anywhere in the Primary Pipeline. |
Manage Fields | A Manage Fields stage is a type of stage that enables you to view field changes, select fields, and edit fields.
You can add or delete a Manage Fields stage in the middle or at the end of a pipeline. |
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:
You can add Union stages to derived datasets only. You can add or delete a Union stage anywhere in the Primary Pipeline. |
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 in the middle or at the end of a pipeline. |