New answers tagged automationstudio
0
votes
Import File Activity Automation - Change field data type to match Data Extension
There are only two ways of doing this:
Update the value in the system exporting the data to the CSV
Import into a data extension with field type Text, and use SQL to process the value into the right ...
0
votes
How to use DE suppression list in the journey builder?
You cannot use suppression list in journey builder send, use Exclusion Script in the journey email activity instead.
In your journey, click on the Email Activity and select the Email
Select the ...
0
votes
Accepted
File drop is being picked by the wrong automation due to similar names
Thanks both for providing your inputs. To summarise we have 2 options to resolve this issue -
Follow proper naming conventions for file drops say starting with campaign name first and avoid using ...
0
votes
Access shared data extension from child BU using SSJS
This works and filters on Email.
var deObj = DataExtension.Init('ENT.Contact_Salesforce');
var filteredRows = deObj.Rows.Lookup(["Email"], [emailAddr]);
2
votes
Accepted
Is there a way to process SQL queries in Salesforce Marketing Cloud based on criteria in another unrelated table?
Here's a pattern that I use for referencing a "parameter" data extension.
You can reference the results of the join in a case statement or in the where-clause, depending on the specifics of ...
Top 50 recent answers are included
Related Tags
automationstudio × 848marketing-cloud × 808
sql × 264
dataextensions × 141
journeybuilder × 129
ssjs × 112
query × 86
automation × 51
ampscript × 33
email × 29
import × 29
data-views × 28
data-extract × 26
soap-api × 24
api × 23
ftp × 23
email-studio × 17
javascript × 15
reporting × 15
sftp × 14
rest-api × 13
mobileconnect × 13
contactbuilder × 13
marketing-cloud-connect × 12
data-export × 11