How to exclude recipients with certain values present in a column?

Hello @rvnth,
when you follow solution
https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/dynamic-content-in-email/td-p/639201
Add all three columns to the target data you can simply use split condition to remove all recipients with all three features added that are not empty.


Marcel

Hi @rvnth ,

You can create workflow as below,

Query1: Fetch all recipients (example, @id greater than 0)

Query2: To fetch recipients who has feature name values feature1, feature2,feature3.

Targeting and filtering dimension: nms:recipient

Condition:

feature table exist such as

      feature_name equals to feature1

AND

feature table exist such as

      feature_name equals to feature2

AND

feature table exist such as

      feature_name equals to feature2

The condition will looks like,

Exclusion Activity:

Select primary set as 'All recipient' and enable generate complement.

Run the workflow. Recipients who has all 3 feature values in feature table will get excluded in complement transition.