Exclude customers based up on the features purchased
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.
