Mfcttrf

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;

1

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

share|improve this question

edited 7 hours ago

Jeremy

1,06766 silver badges88 bronze badges

asked 8 hours ago

Lokesh KumarLokesh Kumar

666 bronze badges

add a comment | 

1

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

share|improve this question

edited 7 hours ago

Jeremy

1,06766 silver badges88 bronze badges

asked 8 hours ago

Lokesh KumarLokesh Kumar

666 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

share|improve this question

edited 7 hours ago

Jeremy

1,06766 silver badges88 bronze badges

asked 8 hours ago

Lokesh KumarLokesh Kumar

666 bronze badges

share|improve this question

edited 7 hours ago

Jeremy

1,06766 silver badges88 bronze badges

asked 8 hours ago

Lokesh KumarLokesh Kumar

666 bronze badges

share|improve this question

edited 7 hours ago

Jeremy

1,06766 silver badges88 bronze badges

asked 8 hours ago

Lokesh KumarLokesh Kumar

666 bronze badges

edited 7 hours ago

Jeremy

1,06766 silver badges88 bronze badges

edited 7 hours ago

Jeremy

1,06766 silver badges88 bronze badges

asked 8 hours ago

Lokesh KumarLokesh Kumar

666 bronze badges

asked 8 hours ago

Lokesh KumarLokesh Kumar

666 bronze badges

1 Answer
1

active

oldest

votes

7

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

share|improve this answer

answered 8 hours ago

JeremyJeremy

1,06766 silver badges88 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
);



);

draft saved

draft discarded

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

Name

Email

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

Name

Email

Required, but never shown

7

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

share|improve this answer

answered 8 hours ago

JeremyJeremy

1,06766 silver badges88 bronze badges

add a comment | 

7

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

share|improve this answer

answered 8 hours ago

JeremyJeremy

1,06766 silver badges88 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

share|improve this answer

answered 8 hours ago

JeremyJeremy

1,06766 silver badges88 bronze badges

share|improve this answer

answered 8 hours ago

JeremyJeremy

1,06766 silver badges88 bronze badges

answered 8 hours ago

JeremyJeremy

1,06766 silver badges88 bronze badges

answered 8 hours ago

JeremyJeremy

1,06766 silver badges88 bronze badges