New answers tagged dataextensions
0
votes
I cannot insert to specific Data Extension Amp script
I don't think there is anything wrong with your Data Extension. But if you check the documentation on InsertDE function, you will find that it only works in emails:
This function applies to email ...
- 20k
0
votes
populate data extension with api response based on values in another data extension
You could have a look at the HTTPGet function in ampscript, and fetch the url when the emails are being generated.
If you want to maintain a DE holding the combination of the location and URL, you can ...
- 20k
0
votes
Getting data extension eventDefinitionKey and Id
You need to provide your own event definition key, when creating an event definition with the /eventDefinitions POST request. This is similar to populating the EVENT DEFINITION KEY when creating the ...
- 20k
0
votes
Connected Marketing cloud connect and record got synced in 2 mins instead of 15 mins
This is simply because the connector polls for new records every 15 minutes, not 15 minutes after the record is created. Let's say it polls 12:00, 12:15, 12:30 and 12:45. Your record is created 12:43. ...
- 20k
0
votes
Can I send an email to one person with several row of DE in SFMC?
The following below is not a full solution but provides enough direction to achieve the outcome.
The customer is receiving multiple emails, but you want each customer to receive just one?
Then, ...
- 2,244
0
votes
Decision Split (or something else) for an AB Test in Journey Builder? Trying to find a solution
You can prepare your Entry Source Data Extension fields and data in advance in Automation Studio by creating an SQL Query Activity that would have a logic to check for the product(s) and then set a ...
- 2,585
0
votes
case : check if field A exist in field B
You do not need to overcomplicate it with a subquery in the CASE-WHEN statement, it is enough to simply compare two fields like that -
SELECT
Id,
Email_source1,
Email_source2,
CASE
WHEN ...
- 2,585
1
vote
I want to sync only those data whose first names are 'Lily' from sales/service cloud to synchronized DE in marketing cloud. Is that possible?
You can only filter based on a boolean field:
Filter the synchronized records you choose to import using the Records
Collection buttons.
-To import all records, select All records.
-To import only ...
- 14.2k
0
votes
Can I use 2 data extensions in 1 multi-step journey builder?
Answering your first question - yes it is possible to evaluate a field in the second DE by creating an Attribute Group and connecting DE#1 and DE#2. Then it is up to you to understand how to settle up ...
- 2,585
1
vote
Any suggestions on better or optimized approach that returns single row from multiple rows based on ROW_NUMBER in SFMC
Since the relevant data is already available in the inner select, the join is unnecessary. Regarding performance, the camps are rather split between join vs sub-queries, until there is data to prove ...
- 86
Top 50 recent answers are included