Import a Table or Dataset into a Derived Dataset

Any of these security requirements:

Prism Datasets: Manage
domain in the Prism Analytics functional area.

Dataset Editor
permission on the derived dataset.

Dataset Owner
permission on the derived dataset.

Any of these security requirements:

Prism Datasets: Manage
domain in the Prism Analytics functional area.

Dataset Viewer
permission on the dataset to import into the derived dataset.

Dataset Editor
permission on the dataset to import into the derived dataset.

Dataset Owner
permission on the dataset to import into the derived dataset.

A derived dataset is based on 1 or more existing tables or datasets. Use derived datasets to blend and combine together data from multiple sources. In order to blend and combine data from multiple sources, you need to import multiple tables or datasets into the derived dataset. When you first create a derived dataset, you base it on an existing table or dataset. Afterward, you must import other tables or datasets into the derived dataset.

When you import a table or dataset into a derived dataset, Workday creates a new pipeline. The pipeline name is the same as the table or dataset name you import. You can add stages to the new pipeline.

Once a derived dataset has multiple tables or datasets imported into it, you can add a stage, such as a Join stage, to the Primary Pipeline to blend data with any other pipeline.

Access the

Edit Dataset Transformations

task for a derived dataset.

On the transformation canvas, click

Primary Pipeline

Add Pipeline

Select a table or dataset from the list.

The transformation canvas displays the new pipeline with the first stage being an

Import

stage. The pipeline name is the same as the table or dataset you imported.

(Optional) Add a stage, such as a Join stage, that blends together data from the Primary Pipeline and the pipeline you added.

Steps: Create a Derived Dataset