Exclude customers based up on the features purchased

[rvnth]

hi there

I have a table containing customers' purchased features. For a specific model, each customer can only purchase two features, and each feature is recorded as a separate entry in the feature table. To exclude customers who have purchased both features or two separate features, I employed a query activity to initially fetch all records where the feature name is included in both feature 1 and feature 2. Following this, I utilized an enrichment activity to retrieve the data in two separate columns.

Now, if I observe feature1 in the column "feature_name1" and feature2 in the column "feature_name2," my objective is to exclude such records. Please suggest on how to accomplish this.

[vprasad · Accepted solution]

Hi,

Use a fork after your enrichment to distribute the records into 2 parts and split with the conditional exclusion for each feature as per your logic. Post exclusion, add a union to club the audience back.

Below is the reference

Above workflow activity use case
Fork Activity : Enables you to split the same audience into 2 different work streams

Split Activity : Helps us to apply conditions on the inbound audience
Union Activity : As the name indicates, we can joining the 2 different streams of union.

Thanks,
Vinay.

[rvnth]

Hi @vprasad ,

I was able to achieve this with the help of split activity after enrichment. 

Thank you for your response.

[vprasad]

@rvnth  Great, 

The Split Activity is a good way to apply any conditions to the inbound audience.

Thanks.
Vinay.