2
votes
Marketing Cloud - SQL - Merge values from three columns into one
Assuming the fields are never null, it's simply:
Concat(PO, ID, Domain) as NewColumn
2
votes
What would be suitable entry source for my journey?
I'm sure there are better ways of doing this but something I've done is use field tracking history in Salesforce to track changes for a particular field. I then have a Salesforce report set up to ...
1
vote
Unique Opens no working
A few things:
Underscores are wildcards in LIKE conditionals in T-SQL. You'll need to escape those with square brackets.
lower() isn't needed as the underlying SQL Server database is case-...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
automationstudio × 751marketing-cloud × 713
sql × 225
dataextensions × 127
journeybuilder × 116
ssjs × 95
query × 74
automation × 41
ampscript × 33
import × 29
email × 28
soap-api × 25
data-views × 23
data-extract × 23
api × 21
ftp × 19
reporting × 15
email-studio × 14
rest-api × 13
contactbuilder × 12
marketingcloudapi × 12
mobileconnect × 11
data-export × 11
sftp × 11
marketing-cloud-connect × 10