You can create a Value Map if you want to replace a source field's value with some other value. For example, if you have a source field Priority, you can create a Value Map as shown in the table below.

Value (Source field value)	Map (Target field value)
High	H
Medium	M
Low	L

You can now use this Value Map in the mapping to replace the value of the target field with H, M, or L based on the value in the corresponding source field. For instance, if the source field's value is High, the target field's value will be H.

This page contains the following information:

Creating a Value Map

Follow the steps given below to create a Value Map.

Important

Before you start creating a Value Map, ensure that the source and target layouts are loaded, and all their fields are listed under their respective nodes.

On the mapping screen, in the Parameters panel, click the Add Parameters and then select Value Map option.

Alternatively, click Configure > DATA TRANSFORMATION > Value Map > Create Value Map.
In the Parameters panel, click the Add Parameters and then select the Value Map option.

Select the scope of the Value Map.

Scope of a Value Map is the context within which it is defined and can be accessible within or across the user groups.

Scope	Description
Global	The Value Maps defined within Global scope are available within all the mappings. By default, Global is selected and a Value Map is saved in the Global scope.
Group	The Value Maps defined within Group scope are available only within the specific user group.
Project	The Value Maps can be defined to be a part of a project. A user can access the Value Map only if the user has got access to that project.

In the Name field, enter the name of Value Map.
Enter the values in the Value and the Map cells in the table on the Create New Value Map screen.

You can also provide these values by uploading a CSV file containing the value-map pairs. In a value-map pair, the value and its corresponding mapped value should be separated by a comma, and each pair should be written in a new line as shown below:

CSV for Value Map

High, H
Medium, M
Low, L
Click Add Row to add another row (if required).

If you want to delete any row, select the respective row and click the Delete icon.
Consider to use the Default Value field and Pick from Source option in case a value is not mapped in the value-map set.
1. In the Default Value field, provide a default value to be used for the target field. Also, if there is no value provided for the source field, this default value will be used for the target field.
  For example, assume that at source, the Priority field has High, Medium, Low, and Trivial as values. You may want to map High, Medium, and Low with H, M, and L respectively as the values in the corresponding field at the destination. For the other value, Trivial, you can either provide a default value or use the Pick from Source option.
  
  If you provide a default value, the same value will be used for all the unmapped values. For instance, if you provide Common as the default value, then Common will be used for Trivial at the destination.
2. Select the Pick from Source checkbox if you want to use the source field value or do not want to use the default value as the Map value for the target field.
Click Save.

The newly created Value Map is added and displayed in the Parameters panel at the following locations based on the selected scope:

Scope	Location in the Parameters panel
Global	Value Map/Global
Group	Value Map/Group
Project	Value Map/Project

You can also change the scope of a Value Map from Group to Global directly from the Parameters Panel by right-clicking the Value Map and selecting the Move to Global option. But, you cannot change the scope of a Value Map from Global to Group.

Using Value Map in a mapping

Follow the steps given below to use a Value Map in a Mapping.

While creating the mapping, select the target field. The selected target field is shown in Mapping Expression area.
In the Parameter panel, click Value Map to expand it.
Click Global, Group, or Project to expand the scope in which the required Value Map lies.
Double-click the Value Map you want to use.
Double-click the source field corresponding to the selected target field.
Connect the output of the source field to the input of the Value Map, and then connect the output of Value Map to the input of the target field.
Click (Save) to save the mapping.

You may be interested in...

What's new

Best practices

Training guides

Frequently asked questions

Adeptia Connect APIs

Adeptia security report

Browser not supported