Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Intersection (Clients from different recipient folders)

rafaelc35759395
Level 2
Level 2

Hi,

I am having an issue about sending emails to only those clients that are added to subscription services. Since I may have the same client at different recipient folders, I want to exclude her/him entirely from my deliveries if she/he did, within a recipient folder, have opted out from subscription services.

08-07-2019 4-12-47 PM.png

08-07-2019 4-24-22 PM.png

I know that usually subscription services are connected to a client ID and not email for example. Therefore, if I have the same client in different folders, the same client will have a different ID in each one. How can I reconcile the data to only consider, from the results of these two queries, the same client (by email) that appears on both subscription lists for the two folders it appears?

Thank you in advance for your support.
Best,

Rafael

2 Replies
Jonathon_wodnicki
Community Advisor
Community Advisor

Hi,

Use intersection activity with 'selection of columns' keyed on email field.

Thanks,

-Jon

Yassine_N
Level 3
Level 3

Hello,

Try to use exclusion its better on field @email