Derived column in a data extension Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) 2019 Community Moderator Election ResultsJourney Building Interaction Event not firingjourney not putting a watermark on the data extensionData Extension Refresh/Sync causes empty SubscriberKeyData extension populated in second step (of automation) not showing for Journey Builder audienceMarketing Cloud Journey Builder no Contacts EvaluatingUpdate a data extension based on the records of another data extensionJourney entry event using new contacts in Data ExtensionUse Data Extension data in Journey Builder in real timeMarketing Cloud - Wait Activity - Automation StudioAccessing live data from triggered Data Extension in my Journey
Determine whether an integer is a palindrome
How much damage would a cupful of neutron star matter do to the Earth?
How to make triangles with rounded sides and corners? (squircle with 3 sides)
New Order #6: Easter Egg
An isoperimetric-type inequality inside a cube
Derived column in a data extension
Why is there so little support for joining EFTA in the British parliament?
Any stored/leased 737s that could substitute for grounded MAXs?
Fit odd number of triplets in a measure?
Problem with display of presentation
Does the main washing effect of soap come from foam?
My mentor says to set image to Fine instead of RAW — how is this different from JPG?
Number of generators of subgroup
newbie Q : How to read an output file in one command line
The test team as an enemy of development? And how can this be avoided?
malloc in main() or malloc in another function: allocating memory for a struct and its members
Why can't fire hurt Daenerys but it did to Jon Snow in season 1?
Should man-made satellites feature an intelligent inverted "cow catcher"?
Can the Haste spell grant both a Beast Master ranger and their animal companion extra attacks?
What is a more techy Technical Writer job title that isn't cutesy or confusing?
Is a copyright notice with a non-existent name be invalid?
What did Turing mean when saying that "machines cannot give rise to surprises" is due to a fallacy?
In musical terms, what properties are varied by the human voice to produce different words / syllables?
How to make an animal which can only breed for a certain number of generations?
Derived column in a data extension
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)
2019 Community Moderator Election ResultsJourney Building Interaction Event not firingjourney not putting a watermark on the data extensionData Extension Refresh/Sync causes empty SubscriberKeyData extension populated in second step (of automation) not showing for Journey Builder audienceMarketing Cloud Journey Builder no Contacts EvaluatingUpdate a data extension based on the records of another data extensionJourney entry event using new contacts in Data ExtensionUse Data Extension data in Journey Builder in real timeMarketing Cloud - Wait Activity - Automation StudioAccessing live data from triggered Data Extension in my Journey
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
The journey builder thats been used has entry event as DE populated with data imported from Automation studio
Can I create a Data extension column with values derived from two other columns in same data extension calculated on the fly once the import from the automation studio is completed?
Example
Amount | Rate | Days | Final Amount ((Amount+ Amount*rate*Days))/Days
30000 | 0.25 | 5 | calculated value
40000 | 0.85 | 15 | calculated value
marketing-cloud dataextensions
edited 2 hours ago
Adam Spriggs
18k42147
asked 6 hours ago
priyapriya
3616
add a comment |
The journey builder thats been used has entry event as DE populated with data imported from Automation studio
Can I create a Data extension column with values derived from two other columns in same data extension calculated on the fly once the import from the automation studio is completed?
Example
Amount | Rate | Days | Final Amount ((Amount+ Amount*rate*Days))/Days
30000 | 0.25 | 5 | calculated value
40000 | 0.85 | 15 | calculated value
marketing-cloud dataextensions
edited 2 hours ago
Adam Spriggs
18k42147
asked 6 hours ago
priyapriya
3616
add a comment |
The journey builder thats been used has entry event as DE populated with data imported from Automation studio
Can I create a Data extension column with values derived from two other columns in same data extension calculated on the fly once the import from the automation studio is completed?
Example
Amount | Rate | Days | Final Amount ((Amount+ Amount*rate*Days))/Days
30000 | 0.25 | 5 | calculated value
40000 | 0.85 | 15 | calculated value
marketing-cloud dataextensions
edited 2 hours ago
Adam Spriggs
18k42147
asked 6 hours ago
priyapriya
3616
The journey builder thats been used has entry event as DE populated with data imported from Automation studio
Can I create a Data extension column with values derived from two other columns in same data extension calculated on the fly once the import from the automation studio is completed?
Example
Amount | Rate | Days | Final Amount ((Amount+ Amount*rate*Days))/Days
30000 | 0.25 | 5 | calculated value
40000 | 0.85 | 15 | calculated value
marketing-cloud dataextensions
marketing-cloud dataextensions
edited 2 hours ago
Adam Spriggs
18k42147
asked 6 hours ago
priyapriya
3616
edited 2 hours ago
Adam Spriggs
18k42147
asked 6 hours ago
priyapriya
3616
edited 2 hours ago
Adam Spriggs
18k42147
edited 2 hours ago
Adam Spriggs
18k42147
edited 2 hours ago
Adam Spriggs
18k42147
18k42147
asked 6 hours ago
priyapriya
3616
asked 6 hours ago
priyapriya
3616
asked 6 hours ago
priyapriya
3616
3616
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
Sure. In your Automation -- instead of importing directly to the final entry data extension, just import into a temporary staging data extension and use a Query Activity to add the rows and calculated values to the entry data extension.
If you don't need this calculated value for a decision split, then you could just calculate the Final Amount with AMPscript in the email. This option wouldn't require any changes to the automation.
answered 2 hours ago
Adam SpriggsAdam Spriggs
18k42147
add a comment |
No you can't. Have your Automation populate a Temp DE and then write a SQL to populate your Journey DE along with the derived column.
Or else, have another DE (DE2) which has a derived field and can join with your journey DE. Link these DEs in the Contact builder and then refer that in the journey
answered 6 hours ago
ManeeshManeesh
1,235730
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%2f258566%2fderived-column-in-a-data-extension%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sure. In your Automation -- instead of importing directly to the final entry data extension, just import into a temporary staging data extension and use a Query Activity to add the rows and calculated values to the entry data extension.
If you don't need this calculated value for a decision split, then you could just calculate the Final Amount with AMPscript in the email. This option wouldn't require any changes to the automation.
answered 2 hours ago
Adam SpriggsAdam Spriggs
18k42147
add a comment |
Sure. In your Automation -- instead of importing directly to the final entry data extension, just import into a temporary staging data extension and use a Query Activity to add the rows and calculated values to the entry data extension.
If you don't need this calculated value for a decision split, then you could just calculate the Final Amount with AMPscript in the email. This option wouldn't require any changes to the automation.
answered 2 hours ago
Adam SpriggsAdam Spriggs
18k42147
add a comment |
Sure. In your Automation -- instead of importing directly to the final entry data extension, just import into a temporary staging data extension and use a Query Activity to add the rows and calculated values to the entry data extension.
If you don't need this calculated value for a decision split, then you could just calculate the Final Amount with AMPscript in the email. This option wouldn't require any changes to the automation.
answered 2 hours ago
Adam SpriggsAdam Spriggs
18k42147
Sure. In your Automation -- instead of importing directly to the final entry data extension, just import into a temporary staging data extension and use a Query Activity to add the rows and calculated values to the entry data extension.
If you don't need this calculated value for a decision split, then you could just calculate the Final Amount with AMPscript in the email. This option wouldn't require any changes to the automation.
answered 2 hours ago
Adam SpriggsAdam Spriggs
18k42147
answered 2 hours ago
Adam SpriggsAdam Spriggs
18k42147
answered 2 hours ago
Adam SpriggsAdam Spriggs
18k42147
answered 2 hours ago
Adam SpriggsAdam Spriggs
18k42147
18k42147
add a comment |
add a comment |
No you can't. Have your Automation populate a Temp DE and then write a SQL to populate your Journey DE along with the derived column.
Or else, have another DE (DE2) which has a derived field and can join with your journey DE. Link these DEs in the Contact builder and then refer that in the journey
answered 6 hours ago
ManeeshManeesh
1,235730
add a comment |
No you can't. Have your Automation populate a Temp DE and then write a SQL to populate your Journey DE along with the derived column.
Or else, have another DE (DE2) which has a derived field and can join with your journey DE. Link these DEs in the Contact builder and then refer that in the journey
answered 6 hours ago
ManeeshManeesh
1,235730
add a comment |
No you can't. Have your Automation populate a Temp DE and then write a SQL to populate your Journey DE along with the derived column.
Or else, have another DE (DE2) which has a derived field and can join with your journey DE. Link these DEs in the Contact builder and then refer that in the journey
answered 6 hours ago
ManeeshManeesh
1,235730
No you can't. Have your Automation populate a Temp DE and then write a SQL to populate your Journey DE along with the derived column.
Or else, have another DE (DE2) which has a derived field and can join with your journey DE. Link these DEs in the Contact builder and then refer that in the journey
answered 6 hours ago
ManeeshManeesh
1,235730
answered 6 hours ago
ManeeshManeesh
1,235730
answered 6 hours ago
ManeeshManeesh
1,235730
answered 6 hours ago
ManeeshManeesh
1,235730
1,235730
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%2f258566%2fderived-column-in-a-data-extension%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
