You can use a fuzzy duplicate check to find duplicate values in product attributes.
This topic explains the required setup and the resulting workflow task.
Setup in Data Quality Studio
Set up a duplicate check as follows:
Duplicate check type = Fuzzy matching.
Use a query with at least the EcoResProduct table.
In the Constraints section, add the desired virtual fields of type Product attribute.
Optionally, in the Merge fields section, add the desired virtual fields of type Product attribute.
Note
The virtual field setup on a duplicate check only applies to the fuzzy duplicate check in Data Entry Workflow.
See also: Set up duplicate check - Fuzzy matching.
Setup in Data Entry Workflow
To enable a fuzzy duplicate check on product attributes, for a data entry workflow, this setup is required:
Data entry step: In a data entry step that precedes the fuzzy duplicate check step, add the product attributes to be used in the fuzzy duplicate check. See also: Add product attribute field.
Fuzzy duplicate check step: Select the applicable duplicate check from Data Quality Studio. See also: Create workflow template step - Fuzzy duplicate check.
Workflow task in Data Entry Workflow
On processing a data entry workflow, if possible duplicate values are found on the product attributes, the assigned user gets a task to compare the entered data with the found possible duplicates.
If duplicate values are found on the product attributes, these are shown on the workflow task. You can review duplicate values. If merge fields are defined in the duplicate check setup, you can merge selected values. See also: Do workflow task.