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?
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.