Skip to main content
Documentation
Documentation
Workday User Guide
Last Updated: 2023-06-23
Change Dataset Field Types

Change Dataset Field Types

  • 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 change the field type of a field in a dataset. You might want to change the field type to:
  • Accommodate some calculations you want to do.
    Example: You could change an Integer field type to a Long field type to use the EPOCH_MS_TO_DATE function on it.
  • Convert a Text field containing Workday ID values (WIDs) to an Instance field.
  • Convert a Text field containing date values into a Date field.
Use the Manage Fields stage to change most field types. However, create a Prism calculated field to make these field type changes:
From Field Type
To Field Type
Function
Text
Date
TO_DATE
Currency
Numeric, Double, Integer, or Long
EXTRACT_AMOUNT
Numeric, Double, Integer, or Long
Currency
BUILD_CURRENCY
Text
Currency
TO_CURRENCY
Instance, Multi-Instance
Multi-Instance
CREATE_MULTI_INSTANCE
  1. Access the
    Edit Dataset Transformations
     task.
  2. Select a dataset pipeline.
  3. Add a Manage Fields stage.
  4. Edit the Manage Fields stage by changing the field type in the Output Type drop-down menu.
    Every Instance field type must have a business object name. If you change the field type to Instance, click the settings icon and enter the business object name.

This content is not part of the Workday Administrator Guide.