I am trying to look at fallout from a CTA. I have created a data set for data designer for the items I would expect the CTA to fire on and another data set for the CTAs fired. I want to merge and only include the items from the expected that are not in CTAs. The CTAs_fired dataset is limited the type of CTA that would be fired from the rule.
In SQL language:
Select * from Expected_CTAs
where Account_SFDC_ID not in
(select Account_SFDC_ID from CTAs_Fired)
Best answer by john_apple
As far as I can tell, this is not a built-in capability of Data Designer (nor Bionic Rules Engine). If you merge and retain all records from both Expected CTAs and CTAs Fired and then do a transform off the merge to filter for just accounts where CTA record ID is Null that would provide an output of Accounts that would expect to have a CTA but did not have one created.