Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Create Mapping Table

Create Mapping Table

You can create a mapping table to define rules to map your input values to your target output values. Mapping tables can contain a maximum of 10,000 rows. You can use mapping tables for mapping to these output types:
  • Ledger accounts
  • Text attribute
    You must select a mapping table definition that has a defined text attribute, or the column doesn't display in the mapping table for configuration.
  • Worktags
  1. Access the
    Create Mapping Table
     task.
  2. On the
    Mapping Table Definition
     prompt, select the mapping table definition you created and click
    OK
    .
    Once you create a mapping table based on the definition, you can't edit the mapping table definition.
    To display accounting worktags for a mapping table when using an Enterprise Interface Builder (EIB), you must edit the template to add the Accounting Worktag columns. See Customize EIB Spreadsheet Template.
  3. As you complete mapping inputs to target output values, consider these guidelines:
    Mapping Functionality
    Guidelines
    Input Values
    For each row, enter a combination of input values that map to a particular output value.
    When you leave value blank, Workday won't evaluate the column for that row.
    Operators
    When entering input values, you can use these operators:
    • NOT: Checks whether a value isn't equal to OR isn't like an input value. Examples: NOT abc, NOT ab?
    • IS NULL: Checks whether a field value is empty.
    • IS NOT NULL: Checks whether a field value isn't empty.
    • IN (list): Checks whether a value is within a set of values. Example: IN (abc, def, xyz).
    • NOT IN (list): Checks whether a value isn't within a set of values. Example: NOT IN (abc, def, xyz).
    Wildcard Expressions
    If you selected to include wildcards when defining a parameter on the mapping definition, use ? to match any single character. Example: 10?0 matches these codes: 1020, 1030, 1080.
    Use * to match any number of characters.
    Example: A*00 matches all codes starting with A and ending with 00, such as A100, A1000, A1100, A1200.
    Range Expressions
    If you selected Range Field on the mapping table definition, enter a Range Start and Range End value.
    You can enter Alphanumeric ranges. Example: A100 - D300
    Workday evaluates range expression as a string. Example: Value of 5 falls outside a range of 1-19, but value of 05 falls within a range of 01-19.
    Output Values
    Select the desired output value resulting from the combination of input values.
    Workday evaluates rules from the top down and once it finds the mapping, it stops further evaluation. We recommend that you order rules from most to least specific.
  4. Click
    OK
     and then
    Done
    .