Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2026-04-17
Create Consolidation Data Mapping Tables

Create Consolidation Data Mapping Tables

  • You've created a consolidation data-mapping table definition.
  • Security:
    Set Up: Data Capture Mapping Table
     domain in the Advanced Close and Consolidation functional area.
You can create a consolidation data-mapping table to define rules to map your input values to your target output values.
You can only create 1 consolidation data-mapping table per mapping table definition, but can create unlimited mapping table definitions for each source system. Mapping tables can contain a maximum of 10,000 rows.
In addition to 1-to-1 mapping, you can also map:
  • One input value to many output values.
  • Many input values to 1 output value.
  • Many input values to many output values.
Once you create a consolidation data-mapping table based on the definition, you can edit mapping table rules (Example: add, delete, reorder) but can't modify mapping definitions, except for changes to the definition name.
  1. Access the
    Create Consolidation Data Mapping Table
     task.
  2. For
    Consolidation Data Mapping Definition
    , select the consolidation data-mapping table definition you previously created, and click
    OK
    .
    Workday displays the mapping table with the structure of the selected definition.
    To display accounting worktags for a consolidation data-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, keep these guidelines in consideration:
    Mapping Functionality
    Guidelines
    Input Values
    For each row, enter a combination of input values that maps to a particular output value.
    If 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 a matching mapping table rule, it stops further evaluation. Therefore, order rules from
    most
     to
    least
     specific using
    Order
    .
  4. Once you complete creating all rules, click
    OK
     and then
    Done
    .