The ‘Deduplication’ function allows you to limit the number of relationships in a selection that contain exactly the same data.
Drag a Deduplicate block onto the selection screen in order to deduplicate records.
Double click the Deduplicate block to open the screen below.
Source and Entity
First, select the source within which the duplication needs to take place.
Maximum number of relations
Then define the ‘Maximum number of relations’. This defines the number of relationships that must remain after executing the deduplication. In other words, by entering the maximum number of relations it is determined how often a relation per deduplication attribute may occur after the deduplication.
The relations to retain are selected at random.
Deduplicate a selection based on the same e-mail address and the maximum number of relations is 1. When there are 3 relations in the selection with the e-mail address email@example.com, the selection result will be limited to one relation with the e-mail address firstname.lastname@example.org.