Create a concatenated field as part of SQL query and use it in Salesforce Adv connector merge key
I am working on setting up a Salesforce Advanced Connector, and use the query mode to select my data. In this selection, I created a custom field called merge key as below, CONCAT(CaseNumber, '_', LastModifiedDate) AS Merge_Key # also tried below, but same result CONCAT(CaseNumber, '_', FORMAT(LastModifiedDate, 'yyyy-MM-dd…
