Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Include Mapping in a Dataset

Include Mapping in a Dataset

  • You've created a mapping table based on the mapping table definition.
You can include mapping to populate a dataset with worktag or ledger account values. To include mapping in a dataset, you must associate the columns in your dataset with the inputs defined in your mapping table definition.
  1. Access the
    Data Catalog
     report.
  2. Right-click the dataset for which you want to use the mapping functionality and select
    Edit
    .
  3. Click
    Add Stage
     and select
    Value Mapping
     to add a new Value Mapping stage.
  4. Select a mapping table you want to use as your mapping rule.
  5. Map the required
    Input Fields
     associating fields in your Prism dataset with input fields from your mapping table. If you map a column in your dataset with no data in the mapping table, Workday ignores the column during the mapping process and uses the remaining columns.
  6. Select
    Output Fields
     and if needed, rename the field names. Ensure that there are no spaces in the names as Workday writes these values to a table. Also for better clarity, consider a naming convention for these fields. Example: inst_ or wtg_.
    Workday provides a
    Condition
     field as an output field. This output field provides link to the mapping rule applied.
  7. After configuring the Prism stage, click
    Done
    .
Workday populates the worktag instances for each transactional line per the mapping rules you defined.