Questions tagged [dataextensions]
ExactTarget - A data extension is a table within the application database that contains your data.
909
questions
0
votes
1answer
20 views
How to Refresh an existing Filtered Data Extension without Filter Activity / Automation?
I know that there is the process to create a filter definition, a filter activity and then have these run inside an automation to automatically update filters.
But this means that you need to ...
0
votes
1answer
30 views
Data extension row retrieval
I have a DE which has a tickbox field with boolean value of true set all the time.Now i want to get the total no of rowcount of my de by using this defaul value
set@neededNumber=RowCount(LookupRows("...
-1
votes
1answer
25 views
Can I create an AND and OR filter and apply that to a data extension
I'd like to create a Data Filter that has AND and OR conditions in it, like
x AND y AND (a OR b OR c)
I'm unable to merge two filters. Is this feasible?
0
votes
1answer
38 views
Ampersand character as value in data extension
Is it possible to have '&' character as an attribute value in the data extension? I am using SQL Query activity to insert the value.
Or is there a better way then my current SQL code. I've ...
1
vote
1answer
31 views
Filtered Synchronized Data Extension
I created a filtered data extension from the SYNCHRONIZED Contact data extension from Salesforce.
There were many fields on that DE, but only one EMAIL type field and I used the Contact ID as related ...
0
votes
2answers
38 views
Deleted Data Extension
There was a data extension that has been deleted. Is there any way to restore this DE or query off of what was deleted?
0
votes
1answer
30 views
Convert UTC to Local time & accounting for DST
In Salesforce Marketing Cloud, we are importing order data into a DE to drive a live, in-person, event registration confirmation email. This data includes the time of a given event in UTC format so ...
0
votes
1answer
21 views
Can I update a Salesforce Synchronized object with data that is stored in a Local Data Extension?
I have a synchronized Object from Salesforce, connected to Marketing Cloud through the MC Connector. However, some of those fields are empty, and I want to fill them through a Landing Page I created ...
1
vote
1answer
21 views
How to add a dynamic value for ordinal #4 in Lookup Function?
I've got 2 Data Extensions. Let's call them A and B
In my Journey, I can only easily include the attributes from the Sendable Data Extension (A) that I'm using to trigger the Journey.
However, I ...
2
votes
1answer
48 views
Can i update data extension with auto generated random value
I want to run an automation for adding random value into data extension field.
I have data extension with name RecordsDe which having 3 field FieldA, FieldB & PKey.
Now i want to add random ...
0
votes
1answer
31 views
LookupOrderedRows In cloudpages
I have an events page that i want to load the event information from a data extension. There will be nothing from a sending DE to match with on the event DE. I want to pull all information from the ...
1
vote
1answer
24 views
Update Data Extension in Parent BU when Data Extension in Child BU gets updated( move data from Child BU to Parent
Can someone please help me with this scenario?
I have a data extension in Child Business Unit and the same data extension in Parent Business Unit. The Child Business Unit gets updated randomly and I ...
0
votes
1answer
12 views
Fire journey via Rest API - Shared Data Extension issue
I am trying to use rest api to fire the journey.
The code is in cloud page , coded by ssjs.
I have successfully triggered the journey , if the target data extension is in the child business unit. but ...
2
votes
2answers
66 views
Can i get latest record from data extension having duplicate records
I am updating my target data extension from the data extensions having multiple records by using sql query by union all in automation studio of marketing cloud.
my query is
SELECT
FieldA,
...
-3
votes
1answer
32 views
SQL query to track non openers in the last 90 days (Marketing Cloud)
Wondering if anyone would be able to help me. I need to build an sql query in Marketing Cloud that allows us to track anyone who hasn't opened an email within the last 90 days.
We have tried to use ...
0
votes
2answers
24 views
How to send emails to filtered attribute groups
I used the Data Designer to link Contacts to some other information in a few Data Extensions. The links were done by primary key (1:1), either Subscriber Key or Email Address (both unique to contact). ...
0
votes
1answer
38 views
Update Data Extension excluding Null values
we have a data extension which needs to get updated from a real time sync through salesforce, Right now we are using a Staging D.E to store the data and then update it to our desired D.E. But the ...
0
votes
1answer
49 views
AMPscript WHILE loop to find highest level Salesforce parent account for record and add to data extension
I have a data extension of Salesforce Leads & Contacts that I want to enter into a journey. The data extension has the following fields.
SubscriberKey (this is the 18-digit Salesforce Lead or ...
0
votes
2answers
32 views
Is it possible to update data extesnion from the another data extensions having different no of fields?
I am having 4 Data Extension with different number of fields but 1 field that is common in all(EmailField) is my primary key.
I want to update my 5th Target Data Extension with the data that is in ...
1
vote
1answer
85 views
Marketing Cloud Query Activity is not pulling in data for newly added fields to target Data Extension
I have a query running as an update to capture the data from source data extension and put it on target Data extension as update the matching records and insert new if not matching.
Yesterday we have ...
-4
votes
3answers
66 views
Update Data Extension by using SQL Query in Automation Studio of Marketing Cloud
i am new to Marketing Cloud i am just learning it, i want to do the following things:
I am having 4 Data Extension De1, De2, De3, De4
De1 having 4 fields(fieldA, fieldB, fieldC, fieldD)
De2 having 2 ...
-1
votes
1answer
43 views
How can i update my master data extension from another data extensions in marketing cloud
I am having as data extension name as MasterDe and i want to add and update it with the data that is in other data extension named as DataDeA, DataDeB and DataDeC.
All these Dataextension having two ...
2
votes
1answer
35 views
Marketing Cloud Journey Data Not Available for Exit Criteria?
Why can't I define journey exit criteria using attributes from journey data, instead of only attributes from contact data, which seem to be all that's available?
I ask because I need to use the ...
0
votes
1answer
21 views
AMPscript Returning a column value from a row only when it matches 2 other column values
I’d like to return a description column value when the values of 2 other columns in that row match the values I set earlier in the code with set @value1 = “X” and set @value2 = “Y”
For example:
set @...
0
votes
3answers
40 views
Ampscript look up to show latest entry
I have created a DE with a date_submit field added so when a contact gets added the time stamp is automatically in there mm/dd/yy/sec.
I have a ampscript lookup where it is working fine in showing ...
1
vote
0answers
54 views
Validation errors while CSV upload
Our company has just started the salesforce and we had a demo tool access we are practicing in that demo account.
While loading data we got the following error.
The following import has completed ...
-1
votes
2answers
49 views
Delete records in a data extension using its primary key with AMPScript
I have a data extension which has around 90 million records and we are trying to keep it updated only for 6 months of data with the date range being a date column inside the D.E, we were doing with ...
0
votes
0answers
27 views
Marketing Cloud Tracking Exports to Data Extensions
I have a multi-business unit marketing cloud setup and I am trying to extract individual email send data to an external website.
I tried to look up querying this data from within automation builder ...
2
votes
1answer
193 views
Does quantity of data extensions impact performance?
In Marketing Cloud, if I begin deleting data extensions, could that do anything to improve the overall loading speed of the UI in the various contexts where Contact Builder data is being referenced?
0
votes
0answers
15 views
How to Create A filtered DataExtension using SSJS
i would like to know , how to create a DE filter programmatically using SSJS core library. often i had to create data filters based on data attributes.
Thank you. Appreciate your help.
1
vote
1answer
72 views
Data Extension CSV export not working correctly
I'm currently transferring some data from an old BU that's being depreciated to a new one. As part of this I've recreated a data extension and am now attempting to export the data from the previous/...
0
votes
1answer
33 views
Special Characters replaced in data extension with SQL Query
I used a series of queries in automation studio and filter activities in automation studio. What I did: Using SQL: copied my original data extension into a new one, added a new column and used a case ...
1
vote
2answers
47 views
Retrieve DE fields in order via SOAP API
I am trying to retrieve DE fields via SOAP API but the response containing the fields is out of order not even in alphabetical. I need them to be in the exact order as what is in the UI. I need this ...
1
vote
2answers
46 views
Salesforce Data Extension still available after changing the Data Retention Policy
I sent an email to a Salesforce Report and, once I changed the Data Retention Policy to the Salesforce Data Extension that is autogenerated with the send (to one day instead of 5 days, by default), ...
1
vote
1answer
39 views
Trying to filter DataExtensions using a Client.ID but we get Filter Property 'Client.ID' is not a retrievable property
We have this little piece of code
$getDERows = new ET_DataExtension_Row();
$getDERows->authStub = $this->soap_client;
$getDERows->filter = array("Property" => "Client.ID", "...
0
votes
2answers
39 views
Synchronized Data Extension doesnt appear in Data Designer
I just synchronized a new object in Marketing Cloud that cames from Salesforce through the native Connector, but the generated Synchronized Data Extension hasn't been added in the Data Designer.
As ...
1
vote
1answer
37 views
Salesforce Marketing Cloud: How to restrict access to All Subscriber from Child BU
We have Production BU and UAT BU in our implementation,We want our developer not to access All Subscriber in UAT BU because of PII issue.
I can control it with Custom role with deny access to All ...
0
votes
1answer
35 views
ExactTarget : sql query from _subscribers is not retriving any record
I have below SQL query in Automation:
SELECT TOP(10) EmailAddress AS EmailAddress,DateUnsubscribed AS DateUnsubscribed,
Status AS Status,SubscriberKey AS SubscriberKey,SubscriberID AS SubscriberID
...
1
vote
1answer
40 views
Send a Second email to subscribers that didnt open 1st email sent via automation studio
I need to create an automation to:
1- Send and Email (from a created email template) to subscribers and informations from a Data Extension DocCobranca.
2- After 2 days has passed I need to make a ...
0
votes
2answers
40 views
SQL Query: Retrieve click data from journey
I am looking for help writing an SQL query to find the data for who clicked on an email in a journey. I already know I can export the subscriber ID and a few other items from the tracking extract but ...
1
vote
2answers
65 views
Data Filters and Measures Error for Unique Opens
I am having an error when trying to implement a data filter using a measure I created. I am implementing this filter to create a filtered data extension. Here are the details:
I am using a data ...
0
votes
0answers
36 views
How to form a Data Extension from other Data extensions
I have 3 DataExtensions
DE1 with
fields(name,EmployeeId(primarykey),Group(GroupA as value))
Eg: Name -test | Name -test2
employee - 123 | employee - 124
Group - GroupA | Group- ...
1
vote
0answers
32 views
write SFMC [Script activity] [SSJS] object Properties to a DE
i my objective is to write object properties(Folder, DE , etc) to a DE , how can i achieve this?
here i tried, unsuccessfully, to write folderID to DE column ID , eventually i would like gather all ...
0
votes
1answer
43 views
Import to Data Extension even if the CSV file has no rows (and has only header)
An import step of my automation fails. I tried to imitate that import manually and I realized that Salesforce does not continue the import when the file is empty. In my case, my file contains only the ...
0
votes
2answers
52 views
Delete rows using a date field inside a data extension
We have a data extension which has around 90 million records and we are trying to filter them out using a date field in the D.E itself for anything older than 6 months. Sp, we can't use data retention ...
1
vote
1answer
32 views
SubscriberKey and exclusion data extension/ exclusion script
When we use a Data Extension as an exclusion Data extension or in an exclusion script, is it enough if we only have the "SubscriberKey" field? It is enough to exclude those contacts?
Or should we also ...
0
votes
1answer
26 views
Data filters on Related Syncronised Data Extensions
I am using both MC and SC which are sync'ed using the Connector.
I have an Account Object and an Opportunity Object that I would like to segment against.
The filter criteria goes like this
...
0
votes
1answer
39 views
How can I use BuildRowsetFromXML to pull XML content from a Data Extension? [closed]
I need to be able to pull this data out and display it in the email content. My understanding is that I need to use BuildRowsetFromXML to parse the XML.
<Details>
<Detail>
...
0
votes
1answer
88 views
filtering sent from unsent emails
I have a Sendable Data Extension with thousands of records. Each record represents an email request and its properties values. I was looking for a way to get a unique id for each row, if any exists. I ...
0
votes
0answers
11 views
Which of the many files with the same naming pattern will be read into the Data Extension in an Import File activity?
I am using an Import File Activity to read data into one of my Data Extension. Every day a new file will be dropped into the FTP folder with the following pattern:
Customers_%%Year%%%%Month%%%%Day%%....
