Change Dataset Field Types
- Any of these security requirements:
- Prism Datasets: Managedomain in the Prism Analytics functional area.
- Dataset Editorpermission on the dataset.
- Dataset Ownerpermission on the dataset.
After importing external data into a dataset, if Workday assigned a different field type than
the one you want, then you can change the field type. 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.
- Assign a field type to a value that Workday doesn't automatically recognize.Example: If Workday doesn't automatically recognize an instance value, change it to the Instance field type.Example: If Workday doesn't automatically recognize a date value, change it to the Date field type.
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 |
- Access theEdit Dataset Transformationstask.
- Select a dataset pipeline (required for derived datasets).
- Add a Manage Fields stage.
- 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.