Derived column in a data extension Announcing the arrival of Valued Associate #679: Cesar...

How do Java 8 default methods hеlp with lambdas?

Flight departed from the gate 5 min before scheduled departure time. Refund options

Does a random sequence of vectors span a Hilbert space?

Random body shuffle every night—can we still function?

2018 MacBook Pro won't let me install macOS High Sierra 10.13 from USB installer

Centre cell vertically in tabularx

How does TikZ render an arc?

Can gravitational waves pass through a black hole?

Did pre-Columbian Americans know the spherical shape of the Earth?

The Nth Gryphon Number

As a dual citizen, my US passport will expire one day after traveling to the US. Will this work?

Was the pager message from Nick Fury to Captain Marvel unnecessary?

How to resize main filesystem

Did any compiler fully use 80-bit floating point?

Derived column in a data extension

Any stored/leased 737s that could substitute for grounded MAXs?

How can I prevent/balance waiting and turtling as a response to cooldown mechanics

Did John Wesley plagiarize Matthew Henry...?

What did Turing mean when saying that "machines cannot give rise to surprises" is due to a fallacy?

The test team as an enemy of development? And how can this be avoided?

How do I say "this must not happen"?

Understanding piped commands in GNU/Linux

Can the Haste spell grant both a Beast Master ranger and their animal companion extra attacks?

latest version of QGIS fails to edit attribute table of GeoJSON file



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;
}







1















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









share|improve this question































    1















    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









    share|improve this question



























      1












      1








      1








      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









      share|improve this question
















      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






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited 2 hours ago









      Adam Spriggs

      18k42147




      18k42147










      asked 6 hours ago









      priyapriya

      3616




      3616






















          2 Answers
          2






          active

          oldest

          votes


















          2














          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.






          share|improve this answer































            0














            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






            share|improve this answer
























              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


















              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









              2














              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.






              share|improve this answer




























                2














                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.






                share|improve this answer


























                  2












                  2








                  2







                  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.






                  share|improve this answer













                  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.







                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered 2 hours ago









                  Adam SpriggsAdam Spriggs

                  18k42147




                  18k42147

























                      0














                      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






                      share|improve this answer




























                        0














                        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






                        share|improve this answer


























                          0












                          0








                          0







                          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






                          share|improve this answer













                          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







                          share|improve this answer












                          share|improve this answer



                          share|improve this answer










                          answered 6 hours ago









                          ManeeshManeesh

                          1,235730




                          1,235730






























                              draft saved

                              draft discarded




















































                              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.




                              draft saved


                              draft discarded














                              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





















































                              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







                              Popular posts from this blog

                              “%fieldName is a required field.”, in Magento2 REST API Call for GET Method Type The Next...

                              How to change City field to a dropdown in Checkout step Magento 2Magento 2 : How to change UI field(s)...

                              變成蝙蝠會怎樣? 參考資料 外部連結 导航菜单Thomas Nagel, "What is it like to be a...