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
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-...
1
vote
Accepted
Add leading 0's to a character string
Let's assume the number you want to pad is stored in a column called YourNumber and you want to achieve a length of 3 characters. So for example 7 would be transformed into 007. To make this happen ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
sql × 797marketing-cloud × 743
automationstudio × 225
query × 206
dataextensions × 158
data-views × 57
journeybuilder × 42
sqlserver × 28
automation × 24
ampscript × 21
data × 20
soql × 19
ssjs × 14
email × 11
date × 11
subscriber × 11
database × 9
sfmc-business-unit × 9
datetime × 8
sql-studio × 8
activity × 7
apex × 6
reporting × 6
marketing-cloud-connect × 6
contact × 5