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
user avatar
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 ...
user avatar
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-...
user avatar

Only top scored, non community-wiki answers of a minimum length are eligible