You need to sign in to do that
Don't have an account?
Ishan Singh 4
I want to update a field to true or false in a DE based on certain criteria using case statement
Purpose:
I want to update a field in ABC Data exteion which has account Id and XYZ boolen field.
If certain account fullfils below criteria then XYZ field shuld be updated to True or False accordingly.
Criteria :
((select accountid from ent.Certifications_JP c
JOIN ent.Product_vod__c_JP p
ON c.Product_AGN__c = p.Id
where p.Name = 'HYP' and c.Active_AGN__c='True')
Then 'True'
Else 'False')
Field which needs to be updated with true or false - XYZ
DE in which XYZ is ABC
This has to be done in SFMC
You can reach out to Success - Salesforce Marketing Cloud page on https://success.salesforce.com/_ui/core/chatter/groups/GroupProfilePage?g=0F9300000001pQ5CAI for better visibility and inputs on your ask.
If this information helps, please mark the answer as best. Thank you