group by email

[rbiri]

Hi

I am trying to find all recipients with same emails ( I have lot of duplicate..) with different consent type.

ex:

email	consent yype
recipient@domain.com	opt out
recipient@domain.com	opt out
recipient@domain.com	opt in

And what I need to get is how many emails i have in my database with same email but different consent log

[ParthaSarathy · Accepted solution]

Hi @rbiri,

Query:

Fetch all recipients, Filter as, Primary key is not empty. 

Complementary information:

Add data > Data linked to the filtering dimension > Data of the filtring dimension >

Add:

@email

@consentTypeAttribute

count(@consentTypeAttribute)

Select 'Group' checkbox for email and consentTypeAttribute alone

In Advanced parameter, check 'Disable automatic adding of PK'

Now you will be getting the count