Introduction Definitions Login User profile Chatbot Menu

Home Campaigns Selections Runs Schedules Monitor

Operation Campaign Working with blocks Connecting blocks Grouping blocks Add Memo Signal Context menus Settings Coding information

Audience Builder (data)

Select & Segment Select Split Sample Switch Deduplication Communication pressure Combine & Exclude Combine Exclude Enrich & Edit Upload file Import file Snapshot Web service Enrichment Datamart Aggregations

Campaign Builder (channels & content)

Channels

Preview Export SMS App messages Webpush Landing page Website personalization Content Newsletter wizard Dynamic content HTML editor Data capture RSS Funnel

Key path

Automation

Execute Schedule Webhook Time zones

Reports

Email reports

Manage

General settings TID info Email info Templates Management dashboard Admin settings

Access & entitlement Email Web Integration Datamarts System Leads Ezines

Entities XML Preference Center Processes Housekeeping Bot click filtering Mail processing and email address status Feedback loop Number of records in Ternair CDP datastores

Deduplication

The deduplicate function allows you to limit the number of relationships in a selection with exactly the same data. In other words, based on (a combination of) fields with the same value, you can exclude records.

Drag a deduplication block to the selection screen and connect an input (selection) block to the deduplication block.

Double-click on the deduplication block to open its settings.

Source/ Entity

Select the source in which the deduplication is to take place.

More details: Source/ Entity/ Key.

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.

Search/Select Entities

This part of the screen shows the different entities that are available to search and select. You can search for entities by scrolling through the list, expanding the entity tree or via the search box.

More details: Search/Select Entities.

Define Selection/ Deduplication Criteria

In this window you can define the condition(s) on which the deduplicate will occur.

More details: Define Selection Conditions.

Limit

Indicate in every deduplicate block whether the number of records should be limited or not by using the ‘Limit’ function.

First, select ‘Off’, ‘Absolute’ or ‘Percentage’.

Then provide the absolute number or percentage per segment.

More details: Limiet.

Block template

More details: Block template.

Description

More details: Description.

Apply/Cancel/Save/Calculate

The deduplicate block is saved and executed immediately after clicking the "Calculate" button.

More details: Apply/ Cancel/ Save/ Calculate.

Example

Double a selection based on the same e-mail address and the maximum number of relations is one. If there are three relations in the selection with the email address info@ternair.com, the selection result will be limited to one relation with the email address info@ternair.com.