function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Ishan Singh 4Ishan Singh 4 

I want to update a field to true or false in a DE based on certain criteria using case statement


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 

SwethaSwetha (Salesforce Developers) 
HI Ishan,

You can reach out to Success - Salesforce Marketing Cloud page on for better visibility and inputs on your ask.

If this information helps, please mark the answer as best. Thank you