Change the Dataset Example Rows

Any of these security requirements:

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

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

Dataset Editor
permission on the dataset.

Dataset Owner
permission on the dataset.

Dataset Viewer
permission on the dataset and the tenant is configured to have the

Enable Prism Dataset Transformations

check box enabled.

Any of these requirements:

Dataset Viewer
permission on the source base dataset.

Dataset Editor
permission on the source base dataset.

Dataset Owner
permission on the source base dataset.

Table Viewer
permission on the source table.

Table Editor
permission on the source table.

Table Owner
permission on the source table.

Workday displays a subset of dataset rows to give you insight into your source data when you edit a dataset. Workday automatically displays the first 20,000 records starting with the first file in the dataset. You can change the example data to select between:

No Example

Default

Custom Example

You can define rules to curate what data you see and how each stage impacts it. When you apply rules to the custom example data displayed, Workday reads the data from the files again and updates the statistics and field information for each field in the inspector panel.

You might want to create custom example rows to get more precise statistics on each field in the inspector panel.

You can disable all example data temporarily to improve responsiveness if your dataset has a lot of fields. After you make some changes to the dataset, such as adding a new stage or calculated field, you can then enable the example data by selecting the number of rows to display.

If you have permissions to view the

View Dataset Transformations

report, then you can change example data but won't be able to save.

Access the

Edit Transformations

task for a derived dataset.

Select

Default Example

This field changes to reflect the current example option selected.

Select

Custom Example

Select

Add First Rule

You can add 1 rule per base dataset or table.

Select a source.

Workday displays the base datasets and tables that you have permission to view.

(Optional) Add a

Description

to help others understand how the rule impacts the data.

Specify Conditions

by creating a conditional rule for the data.

You can add 1 or more conditions.

(Optional) Select

Convert to Advanced

Use the Prism expression language to write a boolean expression. For more information and examples, see Reference: Boolean Expressions.

You can convert rule conditions created in Basic mode to rule expressions in Advanced mode. If you switch back to Basic mode from Advanced mode, you need to define rule conditions again. Workday doesn't convert Advanced mode rule expressions to Basic mode rule conditions.

Apply

the rule.

You can only save the rule if you have Dataset Editor
permission for the current derived dataset.

(Optional)

Download Example Data

You can download the example data displayed to view a snapshot of how your stages impact the data before publishing.

Workday applies the rule to the example data and displays rows that meet the defined conditions.

You can copy and paste the rules for a base dataset to other derived datasets using the same base dataset by selecting the related actions menu by the custom example rule.

Reference: Boolean Expressions

2022R2 What's New Post: Custom Examples for Prism Dataset Transformations