I am trying to update a boolean field of my Data Extension based on the value of some other field. can I use SQL
UPDATE statement to do so? Though when I tried writing this query, it gave me an error
"Incorrect syntax near the keyword 'UPDATE'."
UPDATE cannot work, is there any other approach by which we can do this?
UPDATE [Table1] a SET a.Field1 = 'True' WHERE a.Field2 IN ('1','2','3','4')