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

When to apply negative sign when number is squared

systemd and copy (/bin/cp): no such file or directory

Random body shuffle every night—can we still function?

Keep at all times, the minus sign above aligned with minus sign below

Short story about astronauts fertilizing soil with their own bodies

Does a random sequence of vectors span a Hilbert space?

What are some likely causes to domain member PC losing contact to domain controller?

How does TikZ render an arc?

.bashrc alias for a command with fixed second parameter

In musical terms, what properties are varied by the human voice to produce different words / syllables?

Is there a verb for listening stealthily?

Does the main washing effect of soap come from foam?

Twin's vs. Twins'

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

Why did Bronn offer to be Tyrion Lannister's champion in trial by combat?

3D Masyu - A Die

How does the body cool itself in a stillsuit?

Is there a spell that can create a permanent fire?

Why can't fire hurt Daenerys but it did to Jon Snow in season 1?

One-one communication

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

Can gravitational waves pass through a black hole?

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

Is this Kuo-toa homebrew race balanced?



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

                              Are there any AGPL-style licences that require source code modifications to be public? Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?Force derivative works to be publicAre there any GPL like licenses for Apple App Store?Do you violate the GPL if you provide source code that cannot be compiled?GPL - is it distribution to use libraries in an appliance loaned to customers?Distributing App for free which uses GPL'ed codeModifications of server software under GPL, with web/CLI interfaceDoes using an AGPLv3-licensed library prevent me from dual-licensing my own source code?Can I publish only select code under GPLv3 from a private project?Is there published precedent regarding the scope of covered work that uses AGPL software?If MIT licensed code links to GPL licensed code what should be the license of the resulting binary program?If I use a public API endpoint that has its source code licensed under AGPL in my app, do I need to disclose my source?

                              2013 GY136 Descoberta | Órbita | Referências Menu de navegação«List Of Centaurs and Scattered-Disk Objects»«List of Known Trans-Neptunian Objects»

                              Mortes em março de 2019 Referências Menu de navegação«Zhores Alferov, Nobel de Física bielorrusso, morre aos 88 anos - Ciência»«Fallece Rafael Torija, o bispo emérito de Ciudad Real»«Peter Hurford dies at 88»«Keith Flint, vocalista do The Prodigy, morre aos 49 anos»«Luke Perry, ator de 'Barrados no baile' e 'Riverdale', morre aos 52 anos»«Former Rangers and Scotland captain Eric Caldow dies, aged 84»«Morreu, aos 61 anos, a antiga lenda do wrestling King Kong Bundy»«Fallece el actor y director teatral Abraham Stavans»«In Memoriam Guillaume Faye»«Sidney Sheinberg, a Force Behind Universal and Spielberg, Is Dead at 84»«Carmine Persico, Colombo Crime Family Boss, Is Dead at 85»«Dirigent Michael Gielen gestorben»«Ciclista tricampeã mundial e prata na Rio 2016 é encontrada morta em casa aos 23 anos»«Pagan Community Notes: Raven Grimassi dies, Indianapolis pop-up event cancelled, Circle Sanctuary announces new podcast, and more!»«Hal Blaine, Wrecking Crew Drummer, Dies at 90»«Morre Coutinho, que editou dupla lendária com Pelé no Santos»«Cantor Demétrius, ídolo da Jovem Guarda, morre em SP»«Ex-presidente do Vasco, Eurico Miranda morre no Rio de Janeiro»«Bronze no Mundial de basquete de 1971, Laís Elena morre aos 76 anos»«Diretor de Corridas da F1, Charlie Whiting morre aos 66 anos às vésperas do GP da Austrália»«Morreu o cardeal Danneels, da Bélgica»«Morreu o cartoonista Augusto Cid»«Morreu a atriz Maria Isabel de Lizandra, de "Vale Tudo" e novelas da Tupi»«WS Merwin, prize-winning poet of nature, dies at 91»«Atriz Márcia Real morre em São Paulo aos 88 anos»«Mauritanie: décès de l'ancien président Mohamed Mahmoud ould Louly»«Morreu Dick Dale, o rei da surf guitar e de "Pulp Fiction"»«Falleció Víctor Genes»«João Carlos Marinho, autor de 'O Gênio do Crime', morre em SP»«Legendary Horror Director and SFX Artist John Carl Buechler Dies at 66»«Morre em Salvador a religiosa Makota Valdina»«مرگ بازیکن‌ سابق نساجی بر اثر سقوط سنگ در مازندران»«Domingos Oliveira morre no Rio»«Morre Airton Ravagniani, ex-São Paulo, Fla, Vasco, Grêmio e Sport - Notícias»«Morre o escritor Flavio Moreira da Costa»«Larry Cohen, Writer-Director of 'It's Alive' and 'Hell Up in Harlem,' Dies at 77»«Scott Walker, experimental singer-songwriter, dead at 76»«Joseph Pilato, Day of the Dead Star and Horror Favorite, Dies at 70»«Sheffield United set to pay tribute to legendary goalkeeper Ted Burgin who has died at 91»«Morre Rafael Henzel, sobrevivente de acidente aéreo da Chapecoense»«Morre Valery Bykovsky, um dos primeiros cosmonautas da União Soviética»«Agnès Varda, cineasta da Nouvelle Vague, morre aos 90 anos»«Agnès Varda, cineasta francesa, morre aos 90 anos»«Tania Mallet, James Bond Actress and Helen Mirren's Cousin, Dies at 77»e