Hi everyone,
I have two schemas, feature_cart & feature_purchase and it has a common column name called feature_name. How can i check for a condition like
if feature_name(feature_cart) == feature_name(feature_purchase), then exclude the recipient else send the recipient to further activities.
Thank you for your help.
Hi @rvnth ,
Create a Workflow as below,
Query1: Fetch all recipients from feature_cart schema.
In additional data, add feature_name attribute and give alias as @featureName
Query2: Fetch all recipients from feature_purchase schema.
In additional data, add feature_name attribute and give alias as @featureName
(Basically, alias name should be same for both Schema's Query)
Intersection:
Reconciliation: "A selection of column"
Primary set: select your primary schema
Columns used for the join: Select the alias column, @featureName
And enable 'Generate complement'
Connect the 'Result' transition of intersection with End activity and 'Complement' transition to rest of your activities in workflow.
Now when you run the workflow, common records with same feature name will go to end, and other records you can process in workflow.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.