Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Corrected links that should have been relative instead of absolute.

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)
HighH
MediumM
LowL

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:

Table of Contents
maxLevel3

Creating a Value Map 

Follow the steps given below to create a Value Map.

Tip
titleImportant
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.
  1. 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
  2. In the Parameters panel, click the Add Parameters and then select the Value Map option. 
  3. Select the scope of the Value Map. 

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


    ScopeDescription
    GlobalThe 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.
    GroupThe Value Maps defined within Group scope are available only within the specific user group.
    ProjectThe 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.


  4. In the Name field, enter the name of Value Map.

  5. Enter the values in the Value and the Map cells in the table on the Create New Value Map screen.

    Tip

    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:

    Panel
    bgColorWhite
    titleBGColordefault
    borderStylesolid
    titleCSV for Value Map

    High, H

    Medium, M

    Low, L




  6. Click Add Row to add another row (if required).

    Tip
    If you want to delete any row, select the respective row and click the Delete icon.



  7. 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 HighMediumLow, and Trivial as values. You may want to map High, Medium, and Low with HM, 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. 

      Info
      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.

  8. Click Save.

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

ScopeLocation 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.

  1. While creating the mapping, select the target field. The selected target field is shown in Mapping Expression area.
  2. In the Parameter panel, click Value Map to expand it.
  3. Click GlobalGroup, or Project to expand the scope in which the required Value Map lies.


  4. Double-click the Value Map you want to use.
  5. Double-click the source field corresponding to the selected target field.
  6. 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.

  7. Click  (Save) to save the mapping.