Data Prep Variables can be used in Mapping Groups to create more dynamic mapping rules. Variables values can be specified in the From and To fields of a mapping rule.

To utilize a Data Prep Variable in a mapping rule definition, double click in either the From or To field of the mapping rule. Alternatively, simply start typing a value in either field. With either of these actions, the Variable selector will appear providing access to each of the Variables available in the Mapping Group. The Variable Type (System, Column, Runtime) is indicated for each of the available Variables. You can also search for a Variable using the search box in the selector.

Click the Variable name to add the Variable to the mapping rule. To hide the Variable selector, click the Variable selector icon (<>) or press the Enter key twice. The selector will collapse and the Variable will appear in a blue bubble within the mapping rule.

Mapping rule using Variables

Multiple Variable values can be assigned, combined with a static value, or a combination thereof.

The below table illustrates the impact of the mapping rules in the above example.

Natural Account

Functional Area

Result

Mapping Rule Applied

12050

null

12050

1

400010

Revenue

400010

1

60000

Marketing

Marketing

2

602150

IS

IS

2

73025

null

73025

1

93265

Finance

93265_Finance

3

Using Runtime Variables in Mapping Groups

Runtime Variables are available for use in Data Prep Mapping Groups; however, a corresponding Runtime Variable must be created in the Pipeline in order to allow a value to be passed to the Mapping Group at the point of execution.

💡 Leading Practice Tip: Utilize the same name for the Mapping Group and Pipeline Runtime Variables. Optionally, you may prefix the Variable name with MG_ to provide a visual reminder that the Runtime Variable is utilized by Mapping Groups.

Did this answer your question?