Skip to main content
Documentation
Documentation
Workday User Guide
Last Updated: 2026-03-13
Manage Dataset Fields

Manage Dataset Fields

  • Prism Datasets: Create
     domain in the Prism Analytics functional area when creating a dataset.
  • Any of these security requirements:
    • Prism Datasets: Manage
       domain in the Prism Analytics functional area.
    • Dataset Editor
       permission on the dataset.
    • Dataset Owner
       permission on the dataset.
You can use the Manage Fields stage to view field changes, select fields, and edit fields.
Decide on field names before you define Prism calculated fields and stages. Changing a field name later on will break Prism calculated field expressions and stages that rely on it.
  1. Access the
    Edit Dataset Transformations
     task.
  2. Add a Manage Fields stage to edit fields in the dataset.
    Workday recommends that you add the Manage Fields stage at the:
    • Beginning of the primary pipeline of a derived dataset.
    • End of a primary pipeline that you intend to publish.
  3. As you complete the Manage Fields stage, consider:
    Option Description
    Input Name
    Clear the check box to hide the field from future stages. You can hide fields to protect sensitive data or to use a calculated field instead of the fields that it's based on. Hide unpopulated or sparse fields or Prism calculated fields that do interim processing.
    Output Name
    Ensure that the new name:
    • Doesn't start with ( or with WPA_.
    • Is unique within the dataset.
    • Is unique to any potential future field names that come from the source files.
    When you change a field name in the dataset and add a new field with the same name, you get unexpected results in the data when the schema updates.
    Use the
    Update Output Names
     icon beside the
    Output Name
     column header to update output field names using operations, such as Replace.
    Output Type
    The field type determines which functions can use the field as an argument. Create a Prism calculated field to change a field type to a Date or Currency field type or to change a Currency field type to a numeric field type.
    For numeric types, you can specify the number of digits that go before and after the decimal point.
    For Instance and Multi-Instance types, you can select the business object name and report field associated with the values in the field. To select a report field, enter the Workday ID.
    Numeric field types include Integer, Long, Double, or Numeric.

This content is not part of the Workday Administrator Guide.