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_appleView original