This operation copies the value of one attribute into another attribute. You can specify whether to keep or overwrite existing values. This operation can also be used for local attribute link metadata values.
For example, while performing data cleanup activities, to consolidate duplicate attributes, this operation can be used to copy values from the duplicate attribute to the attribute that should be used to store the value.
This operation can also be run via a Bulk Update and sample data is provided in the Attribute Values: Merge Attribute Values Operation topic in the Bulk Updates documentation here.
Prerequisites
Before using this operation:
- Ensure the source and target attributes are valid for all of the same object types, and for the object on which the business action will be run.
- Ensure the source and target attributes are valid for all of the same product links and classification links.
- Ensure the source and target attributes are valid for all of the same reference types.
- Ensure the source and target attributes have the same dimension dependencies.
- Create a business rule as defined in the Creating a Business Rule, Function, or Library topic here.
Configuration
Note: The Merge Attribute Values operation does not delete any attributes, it can only update values. If desired, manually delete the source attribute once you confirm the merged data.
- On the Edit Operation dialog, from the dropdown select the Workflow group, then select the Merge Attribute Values option.
- For the Merge parameter, click the ellipsis button (
) to display the Select Attribute dialog, choose the attribute to copy values from, and click the Select button.
- For the into parameter, click the ellipsis button () to display the Select Attribute dialog, choose the attribute to copy values to, and click the Select button.
- For the Source Workspace parameter, use the dropdown to select the workspace that holds the values to be copied. Values are always pasted into the Main workspace.
- For the Overwrite parameter, use the dropdown to select one of the following options. Validation errors are displayed when a value cannot be modified. Refer to an illustration of the results in the Merge Results section below.
- Overwrite existing values means the source value overwrites the target value, except when the source attribute is blank. If the source attribute is blank, the target value is not changed.
- Keep Original values means the source value is only copied to the target attribute when the target attribute is blank. If the target attribute contains a value, the target value is not changed.
- For Merge Link Attributes, use the dropdown to select one of the following options. If the selected attributes are both used as an attribute on a reference, a product classification link, or an attribute link, merging of those values are based on the Yes or No set in this parameter, as well as the other parameters on the operation. This option is not relevant when values do not exist on references for the selected attributes.
- Click the Save button to add the operation to the business rule editor.