Is there any SQL Query to update an attribute Touch = 'Touch2' in the DE only if Propensity values lie between 0.6 and 0.7 and Lapsed days lie between 60 and 80 and Qualfying Date is null. Currently tried Update function in SQL , that seems to be not working
2 réponses
Hi, @Anirudh venugopal
In Marketing Cloud, the UPDATE statement is not supported; only the SELECT statement is supported. Therefore, when configuring a SQL Query Activity, you can choose Update under Data Action. If you choose to use Update, it is necessary to set a primary key within the data extension.
