+3I 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.
+5As 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.
+1As 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.
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
