In order to apply any attribute mapping rule, it is important to first map the source node with the target node, thereby identifying the exact match having the relevant attributes. You need to select the rules based on the mapping to be done. The Mapping Rules are divided into three sections – Commonly Used Rules, Advanced Rules and Other Rules.
Let us understand the various types of attribute mapping rules and how to apply them.
Commonly Used Rules
There are three rules under commonly used rules which are as follows:
Copy attribute name from source -> target
Copy attribute value from source -> target
Transform to New Value
Copy Attribute from Source to Target
This rule should be used when the source data, that is, the source attribute value does not need any transformation. Suppose a source catalog uses a certain attribute name and target catalog uses another attribute name which conveys the same meaning, then you can map the attributes. This rule is applied to map source attribute value as is to target attribute.
To copy attribute name from source to target:
Select the source attribute and click on the rule type Copy attribute from source à target from Mapping Rules dropdown.
Once you select the mapping rule, you will land on Create Attribute Mapping page.
On the Create Attribute Mapping page, it displays the following sections based on the selection:
a. Selected Source Attribute where it displays the selected source attribute which you would want to map.
b. Rule Selected which displays the type of rule selected from the list of rules for creating attribute mapping.
Selected Target Attribute section displays [Select Target Attribute from the list on the right] which indicates you select the target attribute from the list on the right.
Once the target attribute is selected the same section gets displayed as Selected Tagert Attribute section with the <name of target attribute>. You can also change the target attribute by clicking Change Target Attribute hyperlink. This will open the dropdown to select the target attribute.
Select the option from Method to select source attribute values for target section that displays three radio options:
None: If you do not want to get involved in any advanced parsing to copy, then select None option.
String Operation: If you want to select the target attribute value without using any complex regular expressions then use the string operations to extract, add, remove, find, and replace string. For more information, refer to String Operations section.
Regular Expression: When you want to transform values into the desired format or a specific required value, select Regex. To configure select Regex, click Configure and it will open the Regular Expression Builder window. For more information, refer to Regular Expression section.
If the source attribute has UoM in a separate field only, then the Method to select source attribute UoM for target section gets displayed. There are two radio options Copy UoM as is from source and Configure UoM Mapping. By default, the option Copy UoM as is from source is selected.
To configure UoM Mapping option, click Configure. A table is displayed with columns - Unique UoMs in source, Mapped UoM in target, and Actions.
For each UoM, you can edit the UoM mapping method from the Actions column. Click 
to select the UoM mapping method. The Select UoM mapping method pop up consists of three options:
Use Source UoM-- for using the source UoM.
Select UoM from target constraint— for using the target constraint UoM.
Enter a UoM manually-- where you can enter UoM value manually. Once you select the Enter a UoM manually mapping method and click Done, the changes are reflected under Mapped UoM in target field.
Note: You can add a blank value for UoM upon which it will take the UoM value as empty.
Note: If there are multiple UoMs, you can simply click 
to copy and paste the values.
You can also add conditions by clicking Add Condition (Optional) which is an optional field at the bottom of the page. Upon clicking, it opens a dialog box with drop-down options where you can select the Attribute, Operator from the list and enter value manually.
If you wish to discard the applied condition, you can delete the conditions by clicking on the delete icon.
If you want to enter any comments for the attribute mapping that you are creating, click Add Comments (Optional) which is also an optional field. You can delete the comment by clicking on the delete icon.
If you want to reset all the changes, click Reset button and you will be prompted to select the target attribute then follow from step no 2.
Once the attribute mapping details are entered, click Save Mapping.
A pop-up with adding attribute map gets displayed.
Once the attribute map is saved successfully it shows Attribute Mapped Successfully and then you land on the Attribute Mapping page where you can see the source and target attribute mapped with the applied rule.
The above screenshot depicts the rule that is applied to map source attribute values as is to target attribute.
Copy Attribute Value from Source to Target
This rule is used when you need to link similar attribute values between two attributes from source to target catalog.
To copy attribute value from source to target:
Select the source attribute and click on the rule type Copy the value of attribute from source à target from Mapping Rules dropdown.
Once you select the mapping rule, you will land on Create Attribute Mapping page.
On the Create Attribute Mapping page, the selected source attribute name gets displayed. Now if you would like to change the source attribute click Change Source Attribute link.
Select the attribute value from the Attribute Value dropdown. If the attribute has UoM values, it will be populated in Attribute UoM textbox.
Select the target attribute from the list on the right side. You can change the selected target attribute value by clicking Change Target Attribute link.
For example, as you can see from the above screenshot the source attribute has an attribute value ‘Thermoplastic’ and the target attribute has value 'Plastic’. Now upon clicking on Save Mapping, thermoplastic will now be normalized to plastic.
You can also add conditions by clicking Add Condition (Optional) which is an optional field at the bottom of the page. Upon clicking, it opens a dialog box with drop-down options where you can select the Attribute, Operator from the list and enter value manually.
If you wish to discard the applied condition, you can delete the conditions by clicking on the delete icon.
If you want to enter any comments for the attribute mapping that you are creating, click Add Comments (Optional) which is also an optional field. You can delete the comment by clicking on the delete icon.
If you want to reset all the changes, click Reset and you will be prompted to select the target attribute then follow from step no 2.
Once the attribute mapping details are correctly entered, click Save Mapping.
A pop-up with adding attribute map gets displayed.
Once the attribute map is saved successfully, a message as Attribute Mapped Successfully gets displayed and then you land on the Attribute Mapping page where you can see the source and target attribute mapped with the applied rule.
Therefore, this rule needs to be applied wherever the source attribute values need to be changed as per the target attribute values.
Transform to New Value
This rule is applied when you need to create a static value for a SKU.
To create a static value for target attribute:
Select the Target Attribute on the right side for which a static value needs to be added and select the rule Transform to New Value from Mapping Rules.
Once you select the mapping rule, you will land on Create Attribute Mapping page.
On the Create Attribute Mapping page, it displays the following sections based on the selection:
Selected Target Attribute where it displays the selected target attribute for which you would want to create a static value. If you wish to change the target attribute at any given time, click on Change Target Attribute hyperlink. This will open the dropdown to select the target attribute.
Rule Selected which displays the type of rule selected from the list of rules for creating attribute mapping.
Enter static value - is where you enter the static value.
You can also add conditions by clicking Add Condition (Optional) which is an optional field at the bottom of the page. Upon clicking, it opens a dialog box with drop-down options where you can select the Attribute, Operator from the list and enter value manually.
If you wish to discard the applied condition, you can delete the conditions by clicking on the delete icon.
If you want to enter any comments for the attribute mapping that you are creating, click Add Comments (Optional) which is also an optional field. You can delete the comment by clicking on the delete icon.
If you want to reset all the changes, click Reset and you will be prompted to select the target attribute then follow from step no 2.
Once the attribute mapping details are correctly entered, click Save Mapping.
The value is now added to the selected target attribute. However, in this case, if we do not apply any condition, the value will be applicable for all SKUs.
Once the attribute map is saved successfully, a message as Attribute Mapped Successfully gets displayed and then you land on the Attribute Mapping page where you can see the source and target attribute mapped with the applied rule.
Advanced Rules
The advanced rules consist of the following rules:
Concatenate multiple values of a source attribute to a target attribute
Split source attribute value/UoM to multiple target attributes
Split source attribute value to explicit target attribute value and UoM
Merge explicit value and UoM to combined target attribute value
Concatenate multiple values of attribute to a target attribute
This rule is applied when you need to combine multiple attribute values of a single source attribute to a single target attribute value wherein the multiple values are now stored as a single string.
To combine multiple value attributes to a single target attribute:
Select the source attribute and click on the rule type Concatenate multiple values of attribute to a target attribute from Mapping Rules dropdown.
Once you select the mapping rule, you will land on Create Attribute Mapping page.
2. On the Create Attribute Mapping page, it displays the following sections based on the selection:
a. Selected Source Attribute where it displays the selected source attribute which you would want to map.
b. The Rule Selected section displays the type of rule selected from the list of rules for creating attribute mapping.
3. Selected Target Attribute section displays [Select Target Attribute from the list on the right] which indicates you select the target attribute from the list on the right.
Once the target attribute is selected the same section gets displayed as Selected Target Attribute section with the <name of target attribute>. You can also change the target attribute by clicking Change Target Attribute hyperlink. This will open the dropdown to select the target attribute.
4. Source Attribute Value(s) section displays all the attribute values present under selected source attribute.
5. Select the option from Method to select source attribute values for target section that displays three radio options:
None: If you do not want to get involved in any advanced parsing to copy, then select None option.
String Operation: If you want to select the target attribute value without using any complex regular expressions then use the string operations to extract, add, remove, find, and replace string. For more information, refer to String Operations section.
Regular Expression: When you want to transform values into the desired format or a specific required value, select Regex. To configure select Regex, click Configure and it will open the Regular Expression Builder window. For more information, refer to Regular Expression section.
6. You can also add conditions by clicking Add Condition (Optional) which is an optional field at the bottom of the page. Upon clicking, it opens a dialog box with drop-down options where you can select the Attribute, Operator from the list and enter value manually.
If you wish to discard the applied condition, you can delete the conditions by clicking on the delete icon.
7. If you want to enter any comments for the attribute mapping that you are creating, click Add Comments (Optional) which is also an optional field. You can delete the comment by clicking on the delete icon.
8. If you want to reset all the changes, click the Reset button and you will be prompted to select the target attribute then follow from step no 2.
9. Once the attribute mapping details are entered, click Save Mapping.
A pop-up with adding attribute map gets displayed.
10. Once the attribute map is saved successfully it shows Attribute Mapped Successfully and then you land on the Attribute Mapping page where you can see the source and target attribute mapped with the applied rule.
Split source attribute value and UoM to multiple target attributes
This rule should be used when you need to split the attribute value and UoM of a single source attribute to be used as two separate values for two different target attributes.
Let us understand how to apply this rule.
To split source attribute value/UoM to multiple target attributes:
Select the source attribute value that has UoM in separate fields ( i.e UoMs are shown in blue font) and click on the rule type Split source attribute value/UoM to multiple target attributes from Mapping Rules dropdown.
Once you select the mapping rule, you will land on Create Attribute Mapping page.
On the Create Attribute Mapping page, it displays the following sections based on the selection:
a. Selected Source Attribute where it displays the selected source attribute which you would want to map.
b. Rule Selected which displays the type of rule selected from the list of rules for creating attribute mapping.
Target Attribute to map the value section is where you need to select target attribute consisting of LoVs. You can also change the target attribute by clicking Change Target Attribute hyperlink. This will open the dropdown to select the target attribute.
Note: If you select a target attribute which doesn’t have LoVs, an error as ‘Load Values required for the select Attribute to continue’ will be prompted.
Select the option from Method to select source attribute values for target section that displays three radio options:
None: If you do not want to get involved in any advanced parsing to copy, then select None option.
String Operation: If you want to select the target attribute value without using any complex regular expressions then use the string operations to extract, add, remove, find, and replace string. For more information, refer to String Operations section.
Regular Expression: When you want to transform values into the desired format or a specific required value, select Regex. To configure select Regex, click Configure and it will open the Regular Expression Builder window. For more information, refer to Regular Expression section.
Target Attribute to map UoM section is where you select the target attributes on the right side for mapping LoV/UoM. You can change the target attribute by clicking Change Target Attribute hyperlink. This will open the dropdown to select the target attribute.
Note: If you select a target attribute which doesn’t have LoVs, an error as ‘Load Values required for the select Attribute to continue’ will be prompted.
You can also add conditions by clicking Add Condition (Optional) which is an optional field at the bottom of the page. Upon clicking, it opens a dialog box with drop-down options where you can select the Attribute, Operator from the list and enter value manually.
If you wish to discard the applied condition, you can delete the conditions by clicking on the delete icon.
If you want to enter any comments for the attribute mapping that you are creating, click Add Comments (Optional) which is also an optional field. You can delete the comment by clicking on the delete icon.
If you want to reset all the changes, click the Reset button and you will be prompted to select the target attribute then follow from step no 2.
Once the attribute mapping details are entered, click Save Mapping.
A pop-up with adding attribute map gets displayed.
Once the attribute map is saved successfully it shows Attribute Mapped Successfully and then you land on the Attribute Mapping page where you can see the source and target attribute mapped with the applied rule.
Split source attribute value to multiple target attributes
This rule is used when you need to split a single attribute value to be used as attribute values for multiple target attributes.
To split a source attribute value to multiple target attributes:
Select the source attribute and click on the rule Split source attribute value to multiple target attributes from Mapping Rules dropdown.
Once you select the mapping rule, you will land on Create Attribute Mapping page.
On the Create Attribute Mapping page, it displays the following sections based on the selection:
a. Selected Source Attribute where it displays the selected source attribute which you would want to map.
b. Rule Selected section displays the type of rule selected from the list of rules for creating attribute mapping.
Target Attribute(s) section displays [Select Target Attribute from the list on the right] which indicates you select the target attribute from the list on the right.
Once the target attribute is selected a dialogue box of Target Attribute1: with the <selected target name> is displayed.
Select the option from Method to select source attribute values for target attribute section that displays the following radio options:
String Operation: If you want to select the target attribute value without using any complex regular expressions then use the string operations to extract, add, remove, find, and replace string. For more information, refer to String Operations section.
Regular Expression: When you want to transform values into the desired format or a specific required value, select Regex. To configure select Regex, click Configure and it will open the
Regular Expression Builder window. For more information, refer to Regular Expression section.
You can map to multiple target attributes by clicking on Map another target attribute + button. Once you click on it, a pop-up with a list of target attributes gets displayed. You can select another target attribute where you want to split the value as shown in the below screenshots.
You can also add conditions by clicking Add Condition (Optional) which is an optional field at the bottom of the page. Upon clicking, it opens a dialog box with drop-down options where you can select the Attribute, Operator from the list and enter value manually.
If you wish to discard the applied condition, you can delete the conditions by clicking on the delete icon.
If you want to enter any comments for the attribute mapping that you are creating, click Add Comments (Optional) which is also an optional field. You can delete the comment by clicking on the delete icon.
If you want to reset all the changes, click the Reset button and you will be prompted to select the target attribute then follow from step no 3.
Once the attribute mapping details are entered correctly, click Save Mapping.
A pop-up with adding attribute map gets displayed.
Once the attribute map is saved successfully it shows Attribute Mapped Successfully and then you land on the Attribute Mapping page where you can see the source and target attribute mapped with the applied rule.
Split source attribute value to explicit target attribute value and UoM
This rule is used when you need to split a single source attribute value to be used explicitly as an attribute value and UoM for a single target attribute.
To split source attribute value to explicit target attribute value and UoM:
Select the source attribute and click the rule Split source attribute value to explicit target attribute value & UoM from Mapping Rules dropdown.
Once you select the mapping rule, you will land on Create Attribute Mapping page.
In the Create Attribute Mapping page, it displays the following sections based on the selection:
a. Selected Source Attribute where it displays the selected source attribute which you would want to map.
b. Rule Selected which displays the type of rule selected from the list of rules for creating attribute mapping.
Selected Target Attribute section displays [Select Target Attribute from the list on the right] which indicates you select the target attribute from the list on the right.
Once the target attribute is selected the same section gets displayed as Selected Target Attribute section with the <name of target attribute>. You can also change the target attribute by clicking Change Target Attribute hyperlink. This will open the dropdown to select the target attribute.
Select the option from Method to select source attribute values for target section that displays three radio options:
String Operation: If you want to select the target attribute value without using any complex regular expressions then use the string operations to extract, add, remove, find, and replace string. For more information, refer to String Operations section.
Regular Expression: When you want to transform values into the desired format or a specific required value, select Regex. To configure select Regex, click Configure and it will open the Regular Expression Builder window. For more information, refer to Regular Expression section.
Select the option from Method to select source attribute UoM for target section that displays three radio options:
String Operation: If you want to select the target attribute value without using any complex regular expressions then use the string operations to extract, add, remove, find, and replace string. For more information, refer to String Operations section.
Regular Expression: When you want to transform values into the desired format or a specific required value, select Regex. To configure select Regex, click Configure and it will open the Regular Expression Builder window. For more information, refer to Regular Expression section.
Static Value: This field allows you to enter a static value for UoM.
You can also add conditions by clicking Add Condition (Optional) which is an optional field at the bottom of the page. Upon clicking, it opens a dialog box with drop-down options where you can select the Attribute, Operator from the list and enter value manually.
If you wish to discard the applied condition, you can delete the conditions by clicking on the delete icon.
If you want to enter any comments for the attribute mapping that you are creating, click Add Comments (Optional) which is also an optional field. You can delete the comment by clicking on the delete icon.
If you want to reset all the changes, click Reset button and you will be prompted to select the target attribute then follow from step no 3.
Once the attribute mapping details are entered, click Save Mapping.
A pop-up with adding attribute map gets displayed.
Once the attribute map is saved successfully it shows Attribute Mapped Successfully and then you land on the Attribute Mapping page where you can see the source and target attribute mapped with the applied rule.
Merge explicit value and UoM to combined target attribute value
This rule should be used when the UoMs and values for an attribute are stored as separate entities in the source catalog, but they need to be stored as a single value in the target catalog.
To merge explicit attribute value and UoM to combined target attribute value:
Select the source attribute and then click the rule Merge explicit value and UoM to combined target attribute value from Mapping Rules dropdown.
Once you select the mapping rule, you will land on Create Attribute Mapping page.
On the Create Attribute Mapping page, it displays the following sections based on the selection:
Selected Source Attribute where it displays the selected source attribute which you would want to map.
Rule Selected which displays the type of rule selected from the list of rules for creating attribute mapping.
Select the Target Attribute name from the target attributes on the right side. You can change the target attribute by clicking Change Target Attribute hyperlink. This will open the dropdown to select the target attribute.
Method to select source attribute values for target section will be displayed with three radio options –
None: If you do not want to get involved in any advanced parsing to copy, then select None option.
String Operation: If you want to select the target attribute value without using any complex regular expressions then use the string operations to extract, add, remove, find, and replace string. For more information, refer to String Operations section.
Regular Expression: When you want to transform values into the desired format or a specific required value, select Regex. To configure select Regex, click Configure and it will open the Regular Expression Builder window. For more information, refer to Regular Expression section.
If the selected source attribute has UoM value only then UoM Mapping option gets displayed. The options under UoM Mapping available are- Copy UoM as is from source and Configure UoM Mapping. By default, Copy UoM as is from source is selected. When you select Configure UoM Mapping option, a table with columns - Unique UoMs in source, Mapped UoM in target, and Actions gets displayed.
For each UoM, you can edit the UoM mapping method from the Actions column. Click 
to select the UoM mapping method. The Select UoM mapping method pop up consists of three options:
Use Source UoM-- for using the source UoM.
Select UoM from target constraint— for using the target constraint UoM.
Enter a UoM manually-- where you can enter UoM value manually. Once you select the Enter a UoM manually mapping method and click Done, the changes are reflected under Mapped UoM in target field.
Note: If there are multiple UoMs, you can simply click 
to copy and paste the values.
You can also add conditions by clicking Add Condition (Optional) which is an optional field at the bottom of the page. Upon clicking, it opens a dialog box with drop-down options where you can select the Attribute, Operator from the list and enter value manually.
If you wish to discard the applied condition, you can delete the conditions by clicking on the delete icon.
If you want to enter any comments for the attribute mapping that you are creating, click Add Comments (Optional) which is also an optional field. You can delete the comment by clicking on the delete icon.
If you want to reset all the changes, click Reset button and you will be prompted to select the target attribute then follow from step no 3.
Once the attribute mapping details are entered, click Save Mapping.
A pop-up with adding attribute map gets displayed.
Once the attribute map is saved successfully it shows Attribute Mapped Successfully and then you land on the Attribute Mapping page where you can see the source and target attribute mapped with the applied rule.
Lookup Value
This rule can be used to look up the source catalog’s attribute value and then use this value to populate in the mapped target attribute.
Steps to apply Lookup value.
Select the source attribute name and click the rule Lookup Value from Mapping Rules dropdown.
Once you select the mapping rule, you will land on Create Attribute Mapping page.
On the Create Attribute Mapping page, it displays the following sections based on the selection:
Selected Source Attribute where it displays the selected source attribute which you would want to map.
Rule Selected which displays the type of rule selected from the list of rules for creating attribute mapping.
Select the Target Attribute from the target attributes on the right side. You can change the target attribute by clicking Change Target Attribute hyperlink. This will open the dropdown to select the target attribute.
Now select the lookup method from the Lookup Method field which consists of the following options:
Use an existing lookup table: Select this option when you already have an existing lookup table with the value that you want to add and you can select the table by clicking on
(edit) option. Create a new lookup table: Select this option when you can create a new lookup table with the attribute values you would want to normalize. Now, when you click on
(Create) option there are two options that populate which are as follows:
Create a lookup table by manually entering the data – select this option if you want to manually enter attribute values i.e. lookup value and result value.
Import a lookup table from the excel or delimited file – select this option if you want to upload an already existing excel or file with the data.
Method to select source attribute values for target section will be displayed with two radio options:
None: If you do not want to get involved in any advanced parsing to copy, then select None option.
String Operation: If you want to select the target attribute value without using any complex regular expressions then use the string operations to extract, add, remove, find, and replace string. For more information, refer to String Operations section.
You can also add conditions by clicking Add Condition (Optional) which is an optional field at the bottom of the page. Upon clicking, it opens a dialog box with drop-down options where you can select the Attribute, Operator from the list and enter value manually.
If you wish to discard the applied condition, you can delete the conditions by clicking on the delete icon.
If you want to enter any comments for the attribute mapping that you are creating, click Add Comments (Optional) which is also an optional field. You can delete the comment by clicking on the delete icon.
If you want to reset all the changes, click Reset button and you will be prompted to select the target attribute then follow from step no 3.
Once the attribute mapping details are entered, click Save Mapping.
A pop-up with adding attribute map gets displayed.
Once the attribute map is saved successfully it shows Attribute Mapped Successfully and then you land on the Attribute Mapping page where you can see the source and target attribute mapped with the applied rule.
Multiple attributes to single
This rule is used when you want to combine multiple source attributes to be used in a single target attribute.
To combine multiple source attribute values to single target attribute:
Select the source attribute and click on the rule Split source attribute value to multiple target attributes from Mapping Rules dropdown.
Once you select the mapping rule, you will land on Create Attribute Mapping page.
On the Create Attribute Mapping page, it displays the following sections based on the selection:
Selected Source Attribute where it displays the selected source attributes which you would want to map. If you want to add any new source attribute, click on Add more attribute+
Rule Selected section displays the type of rule selected from the list of rules for creating attribute mapping.
Target Attribute(s) section displays [Select Target Attribute from the list on the right] which indicates you select the target attribute from the list on the right.
Once the target attribute is selected the field Selected Target Attribute is displayed with the < selected attribute name>.
Advanced String Parsing Logic is a toggle button which is by default is set to No but if you toggle Yes then a table with method to select source attribute value for target gets displays with three radio options:
None: If you do not want to get involved in any advanced parsing to copy, then select None option.
String Operation: If you want to select the target attribute value without using any complex regular expressions then use the string operations to extract, add, remove, find, and replace string. For more information, refer to String Operations section.
Regular Expression: When you want to transform values into the desired format or a specific required value, select Regex. To configure select Regex, click Configure and it will open the Regular Expression Builder window. For more information, refer to Regular Expression section.
Now if you would want to add the parsing logic for the other selected source attributes, click Add parsing logic for another attribute +.
Attribute value mapping pattern section displays the selected source attributes.
Add UoM (optional) toggle is used when you have a source attribute consisting of UoM values and you would want to add a static value for it, then toggle it to Yes. By default, the toggle is set to No.
You can also add conditions by clicking Add Condition (Optional) which is an optional field at the bottom of the page. Upon clicking, it opens a dialog box with drop-down options where you can select the Attribute, Operator from the list and enter value manually.
If you wish to discard the applied condition, you can delete the conditions by clicking on the delete icon.
If you want to enter any comments for the attribute mapping that you are creating, click Add Comments (Optional) which is also an optional field. You can delete the comment by clicking on the delete icon.
If you want to reset all the changes, click the Reset button and you will be prompted to select the target attribute then follow from step no 3.
Once the attribute mapping details are entered correctly, click Save Mapping.
A pop-up with adding attribute map gets displayed.
Once the attribute map is saved successfully it shows Attribute Mapped Successfully and then you land on the Attribute Mapping page where you can see the source and target attribute mapped with the applied rule.
Combine separate source value/UoM to single target
This rule is used when you want to combine separate source attribute value/UoM to single target attribute.
To combine separate source value/UoM to single target attribute:
Select the source attribute and click on the rule Split source attribute value to multiple target attributes from Mapping Rules dropdown.
Once you select the mapping rule, you will land on Create Attribute Mapping page.
On the Create Attribute Mapping page, it displays the following sections based on the selection:
Selected Source Attribute(s) where it displays the selected source attributes which you would want to combine and map. If you want to replace the added source attribute to a new attribute, click on
(edit) icon which will populate the list of source attribute values. Rule Selected section displays the type of rule selected from the list of rules for creating attribute mapping.
Target Attribute(s) section displays [Select Target Attribute from the list on the right] which indicates you select the target attribute from the list on the right.
Once the target attribute is selected the field Selected Target Attribute is displayed with the <selected attribute name>.
Select the option from Advanced string parsing logic for <selected target attribute> which displays three radio options:
None: If you do not want to get involved in any advanced parsing to copy, then select None option.
String Operation: If you want to select the target attribute value without using any complex regular expressions then use the string operations to extract, add, remove, find, and replace string. For more information, refer to String Operations section.
Regular Expression: When you want to transform values into the desired format or a specific required value, select Regex. To configure select Regex, click Configure and it will open the Regular Expression Builder window. For more information, refer to Regular Expression section.
Note: The above section which is from Advanced string parsing logic for <selected target attribute> gets displayed for all the selected source attribute as a separate section in this case we selected two attributes, so the section is displayed twice separately as you can see the image above.
UoM Mapping: The options under UoM mapping are- Copy UoM as is from source and Configure UoM Mapping. By default, Copy UoM as is from source is selected.
When you select Configure UoM Mapping option, a dropdown field gets displayed with the list of selected source attributes and upon selection of the attribute, a table with columns - Unique UoMs in source, Mapped UoM in target, and Actions gets displayed.
For each UoM, you can edit the UoM mapping method from the Actions column. Click 
to select the UoM mapping method. The Select UoM mapping method pop up consists of three options:
Use Source UoM-- for using the source UoM.
Select UoM from target constraint— for using the target constraint UoM.
Enter a UoM manually-- where you can enter UoM value manually. Once you select the Enter a UoM manually mapping method and click Done, the changes are reflected under Mapped UoM in target field.
You can also add conditions by clicking Add Condition (Optional) which is an optional field at the bottom of the page. Upon clicking, it opens a dialog box with drop-down options where you can select the Attribute, Operator from the list and enter value manually.
If you wish to discard the applied condition, you can delete the conditions by clicking on the delete icon.
If you want to enter any comments for the attribute mapping that you are creating, click Add Comments (Optional) which is also an optional field. You can delete the comment by clicking on the delete icon.
If you want to reset all the changes, click the Reset button and you will be prompted to select the target attribute then follow from step no 3.
Once the attribute mapping details are entered correctly, click Save Mapping.
A pop-up with adding attribute map gets displayed.
Once the attribute map is saved successfully it shows Attribute Mapped Successfully and then you land on the Attribute Mapping page where you can see the source and target attribute mapped with the applied rule.
Arithmetic Expression
This rule should be used when you need to create an arithmetic formula to derive the value for a target attribute by using the following options:
Hard coded numbers
Source attribute names
Arithmetic operators: +, –, *, /, and parenthesis – honoring the rules of arithmetic operations.
Functions: round, min, max etc.
Using this rule, you can change the value for the target attribute by creating an arithmetic formula.
To create an arithmetic expression to derive the value of a target attribute:
Select the target attribute and click on the rule type Arithmetic Expression from Mapping Rules dropdown.
Once you select the mapping rule, you will land on Create Attribute Mapping page.
Selected Target Attribute section displays the target attribute and if you want to replace the added target attribute to a new attribute, click on change target attribute
(edit) icon which will populate the list of target attribute values. Expression Builder: Select the Source Attribute on the left side, which is the value to be converted and you can see the selected attribute populated in the Expression Builder or you can directly create the formula as needed.
Expression Components (click to insert) is what helps you build the formula by using these expression components such as Binary Operators such as Add, Multiple, Divide, Subtract or Segregators such as open/close parenthesis and Functions such as round up, round down and greatest.
Example - To convert a value from mm to cm, you need to divide the value by 10. Based on the Expression Components available, you need to create the formula. Now to create the formula as needed using the various operators and functions available, click the operator Divide/ and type the value 10 to create the required formula.
Once, the expression is created the following options are available to modify it:
Undo
– Click this to revert any changes made.Clear
– Click this to clear the equation string that has been built in the expression builder.Validate
– Click this to validate the equation syntax and the following is displayed.In case of an incorrect formula or if the expression is syntactically incorrect, a warning message ‘Expression contains invalid characters’ gets displayed.
Once the desired formula is created, click Save Mapping and the target attribute is updated with attribute value and UoM based on the formula applied.
A pop-up with adding attribute map gets displayed.
Once the attribute map is saved successfully it shows Attribute Mapped Successfully and then you land on the Attribute Mapping page where you can see the source and target attribute mapped with the applied rule.
If you want to reset all the changes, click the Reset button and select the target attribute then follow from step no 2.
Other Rules
Other rules currently consist of only Suppress/Unsuppress rule as detailed below:
Suppress/Unsuppress
This rule enables you to manually mark an attribute as ‘suppressed’. Suppressed attributes cannot be mapped. You will have to unsuppress an attribute to make it eligible for mapping.
NOTE | You cannot suppress taxonomy nodes in source catalog as they are not eligible. Only source attributes within a node map can be suppressed. |
To suppress an attribute:
1. Select the source attribute and click the rule Suppress/Unsuppress from Mapping Rules dropdown.
2. A list of source attributes present in the node is displayed. You can also search for the attribute you need to suppress from the Search field.
3. Turn on the toggle for the attribute to be suppressed and click Done as shown below.
NOTE | In case an attribute is already mapped, you cannot suppress that attribute as it contains mapping information as shown below. If you still need to suppress it, you first need to remove all the maps and then suppress the attribute. |
To unsuppress an attribute:
1. Select the Source Attribute and then click the rule Suppress/Unsuppress from Mapping Rules dropdown.
2. A list of source attributes present in the node gets displayed and you can also search for the attribute you need to suppress. The suppressed attribute will be denoted with a red cross which means it is suppressed.
3. Turn off the toggle for the attribute to be unsuppressed and click Done.