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

[rvnth]

Hi everyone, 

I have  a features table linked with recipient , feature table contains feature_name column with values (feature1, feature2,feature3) and I wanted to know how to exclude recipients if they have all the three features available. Below is table level representation

recipinet    feature_name

recipient1  feature1

recipient1  feature2

recipient1  feature3

Thank you in advance

[Marcel_Szimonisz]

Hello @rvnth,
when you follow solution
https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/dynamic-content-in...
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

[ParthaSarathy]

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.