how to retrieve all recipients with same email with a different consent type?

[rbiri]

Hello

I am trying  to retrieve all recipents with same email but coming with a différent consent type?

I am looking for a straight foward approach, to update them with the same value consent type, when the most recent consent date is updated?

[ParthaSarathy · Accepted solution]

Hi @rbiri ,

Create a workflow as below,

Query:

Fetch all recipients (Filtering Condition: Primary key is not empty)

Deduplication:

Targeting dimension: Temporary schema

Identification of duplicate: [target/@email]

Duplicate Method:

Configure exactly same as below,

This will select the latest updated / Modified record.

Update Data:

Operation type: Update

Select 'Using Reconciliation key'

Reconcile using Email and [target/@email]

Fields to update:
In the below screenshot, instead of middle name, configure consent type from your schema

Now all the records with same email Id have its latest Consent type.