I have a journey in which entry criteria is Salesforce Data. Whenever a contact enters into a journey, the journey puts its details into a DE(created by the journey itself). I want to write automation to delete the records which are 90 days older in that DE. While writing SQL, I am getting an error as the DE created by the journey contains special characters(:,;) in the field name.
Renaming the field name is also not an option as it makes us lose data from the journey.
Is there any workaround or an alternate solution for this?
Select * from DE where [Inquiry__c:Lead__r:Email] = "XX@XX.com"
? – zuzannamj Nov 3 '19 at 18:23