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,626
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 ...
- 541
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-...
- 28k
Only top scored, non community-wiki answers of a minimum length are eligible