|
Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Workiva Support Center

Manage groups for Mapping transformations

Manage groups for Mapping transformations

  • Last updated on

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.

create-mapping-group_02.png

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.
    create-mapping-group_03.png
  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.

edit-group-rules_01.png

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.
    copy-mapping-groups_01.png
  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.
    archive-mapping-groups_01.png
  • In the mapping group, select Archive from its menu.
    archive-mapping-group_02.png

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.
Mapping groups define the rules to apply to tabular data with Mapping transformations in pipelines. From Mapping grou...