Workiva Support Center

Mapping groups define the rules to apply to tabular data with Mapping transformations in pipelines. From Mapping groups library_books, you can manage the mapping groups available for use with pipelines.

Requirements

Data Prep is controlled entirely at the org level and does not recognize individual workspaces or their permissions.

This means:

• Data Prep is shared among all authorized users in your org.
• Any user with access to Chain Builder also has access to Data Prep.
• All users who can create or edit chains will have the ability to manage pipelines in Data Prep.
• A single Data Prep pipeline can be used across multiple chains and workspaces within an organization.
  
  

Edit a mapping group's column definition

A mapping group's column definition includes:

• The primary column, which contains the values changed by the Mapping transformation
• Any additional columns with values to consider for conditional mapping rules

To edit a mapping group's column, on the Columns view_column tab, click Edit columns, and update its data type or name as necessary.

To add a new column to the mapping group:

1. On the Columns view_column tab, click Edit columns.
2. Under Define columns, click Add column.
   
3. In Data type, select the type of data in the source column to transform.
4. Enter a name of the new column.
5. Click Save.

To use the updated columns with Mapping transformations, click Publish.

Edit a mapping group's rules

To add or manage the rules a mapping group applies to tabular data, select its Rules gavel tab.

Copy a mapping group

To create a new mapping group with similar columns and rules as another group, start with a copy of the existing group. 

1. From Mapping groups library_books, click Copy file_copy for the existing group to create a duplicate.
   
2. Edit the name of the duplicate group, and click OK.
3. Update the columns and rules of the new group as necessary.
4. To use the new group with a Mapping transformation, click Publish.

Archive a mapping group

If you no longer use a mapping group, archive it as a read-only version, such as for audit requests:

• From Mapping groups library_books, select the Active tab, and click Archive archive for the group.
  
• In the mapping group, select Archive from its menu.
  

To return an archived group to Active status, on the Archived tab, click Restore for the group.

Delete a mapping group

Note: When you delete a mapping group, you can't recover it. To download a CSV of a group's rules as a backup before you delete, click Download on its Rules tab.

To completely remove a mapping group and its history:

1. From Mapping groups library_books, archive the mapping group if necessary.
2. On the Archived tab, click Delete delete for the group.
3. In Confirm, enter delete.
4. Click Delete.