Marketing Cloud Query Activity is not pulling in data for newly added fields to target Data ExtensionQuery activity for records created today not workingupdate data extension with query activityQuery - Data Extension with Query ActivityMarketing Cloud Query Activity in AutomationTrigger entry event when new rows are added to data extension [Salesforce Marketing Cloud]what update type to use in query for adding and updating in data extensionUsing “Update” for Target Data ExtensionMarketing Cloud Automation studio won't update data extensionMarketing Cloud update activity fails for primary key violationHow to update a field in target Data Extension in marketing cloud
What to do when you reach a conclusion and find out later on that someone else already did?
Is the apartment I want to rent a scam?
Marketing Cloud Query Activity is not pulling in data for newly added fields to target Data Extension
How do I run a game when my PCs have different approaches to combat?
"I you already know": is this proper English?
Other than a swing wing, what types of variable geometry have flown?
Is the 2-Category of groupoids locally presentable?
Why are off grid solar setups only 12, 24, 48 VDC?
High income, sudden windfall
What are the exact meanings of roll, pitch and yaw?
Sextortion with actual password not found in leaks
Explanation for a joke about a three-legged dog that walks into a bar
Do Rabbis get punished in Heaven for wrong interpretations or claims?
Does static fire reduce reliability?
The seven story archetypes. Are they truly all of them?
Should I leave my PhD after 3 years with a Masters?
Film where a boy turns into a princess
What is the meaning of "you has the wind of me"?
How to write a sincerely religious protagonist without preaching or affirming or judging their worldview?
What do teaching faculty do during semester breaks?
Who has jurisdiction for a crime committed in an embassy?
Why do people say "I am broke" instead of "I am broken"?
Why no ";" after "do" in sh loops?
Sitecore Powershell extensions module compatibility with Sitecore 9.2
Marketing Cloud Query Activity is not pulling in data for newly added fields to target Data Extension
Query activity for records created today not workingupdate data extension with query activityQuery - Data Extension with Query ActivityMarketing Cloud Query Activity in AutomationTrigger entry event when new rows are added to data extension [Salesforce Marketing Cloud]what update type to use in query for adding and updating in data extensionUsing “Update” for Target Data ExtensionMarketing Cloud Automation studio won't update data extensionMarketing Cloud update activity fails for primary key violationHow to update a field in target Data Extension in marketing cloud
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
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 added a new field in the target data extension to get the data from the source data extension. This field was already present in the source Data extension.
Issue is my query ran and the newly added field is coming as a blank but the value is present in the source data extension field.
Records are coming from source data extension to target but all records are having the newly created field as a blank.
Why do I observe this behavior? How do I fix it?
marketing-cloud dataextensions
edited 7 hours ago
Jeremy
1,0676 silver badges8 bronze badges
asked 8 hours ago
Lokesh KumarLokesh Kumar
66 bronze badges
add a comment |
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 added a new field in the target data extension to get the data from the source data extension. This field was already present in the source Data extension.
Issue is my query ran and the newly added field is coming as a blank but the value is present in the source data extension field.
Records are coming from source data extension to target but all records are having the newly created field as a blank.
Why do I observe this behavior? How do I fix it?
marketing-cloud dataextensions
edited 7 hours ago
Jeremy
1,0676 silver badges8 bronze badges
asked 8 hours ago
Lokesh KumarLokesh Kumar
66 bronze badges
add a comment |
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 added a new field in the target data extension to get the data from the source data extension. This field was already present in the source Data extension.
Issue is my query ran and the newly added field is coming as a blank but the value is present in the source data extension field.
Records are coming from source data extension to target but all records are having the newly created field as a blank.
Why do I observe this behavior? How do I fix it?
marketing-cloud dataextensions
edited 7 hours ago
Jeremy
1,0676 silver badges8 bronze badges
asked 8 hours ago
Lokesh KumarLokesh Kumar
66 bronze badges
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 added a new field in the target data extension to get the data from the source data extension. This field was already present in the source Data extension.
Issue is my query ran and the newly added field is coming as a blank but the value is present in the source data extension field.
Records are coming from source data extension to target but all records are having the newly created field as a blank.
Why do I observe this behavior? How do I fix it?
marketing-cloud dataextensions
marketing-cloud dataextensions
edited 7 hours ago
Jeremy
1,0676 silver badges8 bronze badges
asked 8 hours ago
Lokesh KumarLokesh Kumar
66 bronze badges
edited 7 hours ago
Jeremy
1,0676 silver badges8 bronze badges
asked 8 hours ago
Lokesh KumarLokesh Kumar
66 bronze badges
edited 7 hours ago
Jeremy
1,0676 silver badges8 bronze badges
edited 7 hours ago
Jeremy
1,0676 silver badges8 bronze badges
edited 7 hours ago
Jeremy
1,0676 silver badges8 bronze badges
1,0676 silver badges8 bronze badges
asked 8 hours ago
Lokesh KumarLokesh Kumar
66 bronze badges
asked 8 hours ago
Lokesh KumarLokesh Kumar
66 bronze badges
asked 8 hours ago
Lokesh KumarLokesh Kumar
66 bronze badges
66 bronze badges
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You will need to re-save your query. The query itself is saved and hard-coded on the Marketing Cloud's side and any type of updates like this will not automatically carry over. This is why it is best practice to specify each column name in your query so you avoid this and are forced to update the query anytime you update fields in your data extensions.
This is mentioned in our docs here: SQL Query Activity
answered 8 hours ago
JeremyJeremy
1,0676 silver badges8 bronze badges
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "459"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsalesforce.stackexchange.com%2fquestions%2f271041%2fmarketing-cloud-query-activity-is-not-pulling-in-data-for-newly-added-fields-to%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You will need to re-save your query. The query itself is saved and hard-coded on the Marketing Cloud's side and any type of updates like this will not automatically carry over. This is why it is best practice to specify each column name in your query so you avoid this and are forced to update the query anytime you update fields in your data extensions.
This is mentioned in our docs here: SQL Query Activity
answered 8 hours ago
JeremyJeremy
1,0676 silver badges8 bronze badges
add a comment |
You will need to re-save your query. The query itself is saved and hard-coded on the Marketing Cloud's side and any type of updates like this will not automatically carry over. This is why it is best practice to specify each column name in your query so you avoid this and are forced to update the query anytime you update fields in your data extensions.
This is mentioned in our docs here: SQL Query Activity
answered 8 hours ago
JeremyJeremy
1,0676 silver badges8 bronze badges
add a comment |
You will need to re-save your query. The query itself is saved and hard-coded on the Marketing Cloud's side and any type of updates like this will not automatically carry over. This is why it is best practice to specify each column name in your query so you avoid this and are forced to update the query anytime you update fields in your data extensions.
This is mentioned in our docs here: SQL Query Activity
answered 8 hours ago
JeremyJeremy
1,0676 silver badges8 bronze badges
You will need to re-save your query. The query itself is saved and hard-coded on the Marketing Cloud's side and any type of updates like this will not automatically carry over. This is why it is best practice to specify each column name in your query so you avoid this and are forced to update the query anytime you update fields in your data extensions.
This is mentioned in our docs here: SQL Query Activity
answered 8 hours ago
JeremyJeremy
1,0676 silver badges8 bronze badges
answered 8 hours ago
JeremyJeremy
1,0676 silver badges8 bronze badges
answered 8 hours ago
JeremyJeremy
1,0676 silver badges8 bronze badges
answered 8 hours ago
JeremyJeremy
1,0676 silver badges8 bronze badges
1,0676 silver badges8 bronze badges
add a comment |
add a comment |
Thanks for contributing an answer to Salesforce Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsalesforce.stackexchange.com%2fquestions%2f271041%2fmarketing-cloud-query-activity-is-not-pulling-in-data-for-newly-added-fields-to%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
