AMPScript Lookup From Child Business UnitExact Target Ampscript Data Extension Key, what is it?Receiving parse error for landing page HTML BodyData extension field name is invalid, multiple errorsSimple conditional statementHow do I call a Content Block into an Email built with Content Builder?How to use a LookUp function inside FormatNumber functionValidation error message when activating a journeyAmscript error in marketing cloud salesforceAmpscript works in preview and test but not in live sendAmpscript Error when editing HTML TXT

Alias for root of a polynomial

Why are BJTs common in output stages of power amplifiers?

How to make a not so good looking person more appealing?

Would life always name the light from their sun "white"

How to redirect stdout to a file, and stdout+stderr to another one?

Fixed width with p doesn't work

Problem in downloading videos using youtube-dl from unsupported sites

Could there be a material that inverts the colours seen through it?

Is there any good reason to write "it is easy to see"?

Why weren't the bells paid heed to in S8E5?

Help understanding this line - usage of くれる

Offered a new position but unknown about salary?

Under what charges was this character executed in Game of Thrones, The Bells?

Single word that parallels "Recent" when discussing the near future

The meaning of the Middle English word “king”

Why does lemon juice reduce the "fish" odor of sea food — specifically fish?

Why does the headset man not get on the tractor?

"The van's really booking"

Is this a group? If so, what group is it?

How to continually let my readers know what time it is in my story, in an organic way?

Adding labels and comments to a matrix

AMPScript Lookup From Child Business Unit

Find the unknown area, x

How do I identify the partitions of my hard drive in order to then shred them all?



AMPScript Lookup From Child Business Unit


Exact Target Ampscript Data Extension Key, what is it?Receiving parse error for landing page HTML BodyData extension field name is invalid, multiple errorsSimple conditional statementHow do I call a Content Block into an Email built with Content Builder?How to use a LookUp function inside FormatNumber functionValidation error message when activating a journeyAmscript error in marketing cloud salesforceAmpscript works in preview and test but not in live sendAmpscript Error when editing HTML TXT






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








1















I have a shared data extension that lives in our main business unit, but, is shared across all child business units. I am trying to do a lookup inside the child business unit in content builder. In content builder the lookup is validated but in Journey Builder it kicks me a validation error.



Here is the ampscript:



%%[
set @key = [id]
set @fname = Lookup ('shoppers', 'first_name', 'id', @key)
]%%


Here is the validation error:




Error 1: Script SET Statement Invalid An error occurred when
attempting to resolve a script expression. See inner exception for
detail. Script Expression: Lookup ('shoppers', 'first_name', 'id',
@key) MemberID: 100012513 JobID: 0 The Data Extension name for a
Lookup function call is invalid. A Data Extension of this name does
not exist. Data Extension Name: shoppers Function Call: Lookup
('shoppers', 'first_name', 'id', @key) Parameter Name:
DataExtensionName Parameter Ordinal: 1 Invalid Content: set @fname =
Lookup ('shoppers', 'first_name', 'id', @key) There is an error in
your email. Please contact your customer service representative. Error
1: Script SET Statement Invalid An error occurred when attempting to
resolve a script expression. See inner exception for detail. Script
Expression: Lookup ('shoppers', 'first_name', 'id', @key) MemberID:
100012513 JobID: 0 The Data Extension name for a Lookup function call
is invalid. A Data Extension of this name does not exist. Data
Extension Name: shoppers Function Call: Lookup ('shoppers',
'first_name', 'id', @key) Parameter Name: DataExtensionName Parameter
Ordinal: 1 Invalid Content: set @fname = Lookup ('shoppers',
'first_name', 'id', @key)











share|improve this question




























    1















    I have a shared data extension that lives in our main business unit, but, is shared across all child business units. I am trying to do a lookup inside the child business unit in content builder. In content builder the lookup is validated but in Journey Builder it kicks me a validation error.



    Here is the ampscript:



    %%[
    set @key = [id]
    set @fname = Lookup ('shoppers', 'first_name', 'id', @key)
    ]%%


    Here is the validation error:




    Error 1: Script SET Statement Invalid An error occurred when
    attempting to resolve a script expression. See inner exception for
    detail. Script Expression: Lookup ('shoppers', 'first_name', 'id',
    @key) MemberID: 100012513 JobID: 0 The Data Extension name for a
    Lookup function call is invalid. A Data Extension of this name does
    not exist. Data Extension Name: shoppers Function Call: Lookup
    ('shoppers', 'first_name', 'id', @key) Parameter Name:
    DataExtensionName Parameter Ordinal: 1 Invalid Content: set @fname =
    Lookup ('shoppers', 'first_name', 'id', @key) There is an error in
    your email. Please contact your customer service representative. Error
    1: Script SET Statement Invalid An error occurred when attempting to
    resolve a script expression. See inner exception for detail. Script
    Expression: Lookup ('shoppers', 'first_name', 'id', @key) MemberID:
    100012513 JobID: 0 The Data Extension name for a Lookup function call
    is invalid. A Data Extension of this name does not exist. Data
    Extension Name: shoppers Function Call: Lookup ('shoppers',
    'first_name', 'id', @key) Parameter Name: DataExtensionName Parameter
    Ordinal: 1 Invalid Content: set @fname = Lookup ('shoppers',
    'first_name', 'id', @key)











    share|improve this question
























      1












      1








      1








      I have a shared data extension that lives in our main business unit, but, is shared across all child business units. I am trying to do a lookup inside the child business unit in content builder. In content builder the lookup is validated but in Journey Builder it kicks me a validation error.



      Here is the ampscript:



      %%[
      set @key = [id]
      set @fname = Lookup ('shoppers', 'first_name', 'id', @key)
      ]%%


      Here is the validation error:




      Error 1: Script SET Statement Invalid An error occurred when
      attempting to resolve a script expression. See inner exception for
      detail. Script Expression: Lookup ('shoppers', 'first_name', 'id',
      @key) MemberID: 100012513 JobID: 0 The Data Extension name for a
      Lookup function call is invalid. A Data Extension of this name does
      not exist. Data Extension Name: shoppers Function Call: Lookup
      ('shoppers', 'first_name', 'id', @key) Parameter Name:
      DataExtensionName Parameter Ordinal: 1 Invalid Content: set @fname =
      Lookup ('shoppers', 'first_name', 'id', @key) There is an error in
      your email. Please contact your customer service representative. Error
      1: Script SET Statement Invalid An error occurred when attempting to
      resolve a script expression. See inner exception for detail. Script
      Expression: Lookup ('shoppers', 'first_name', 'id', @key) MemberID:
      100012513 JobID: 0 The Data Extension name for a Lookup function call
      is invalid. A Data Extension of this name does not exist. Data
      Extension Name: shoppers Function Call: Lookup ('shoppers',
      'first_name', 'id', @key) Parameter Name: DataExtensionName Parameter
      Ordinal: 1 Invalid Content: set @fname = Lookup ('shoppers',
      'first_name', 'id', @key)











      share|improve this question














      I have a shared data extension that lives in our main business unit, but, is shared across all child business units. I am trying to do a lookup inside the child business unit in content builder. In content builder the lookup is validated but in Journey Builder it kicks me a validation error.



      Here is the ampscript:



      %%[
      set @key = [id]
      set @fname = Lookup ('shoppers', 'first_name', 'id', @key)
      ]%%


      Here is the validation error:




      Error 1: Script SET Statement Invalid An error occurred when
      attempting to resolve a script expression. See inner exception for
      detail. Script Expression: Lookup ('shoppers', 'first_name', 'id',
      @key) MemberID: 100012513 JobID: 0 The Data Extension name for a
      Lookup function call is invalid. A Data Extension of this name does
      not exist. Data Extension Name: shoppers Function Call: Lookup
      ('shoppers', 'first_name', 'id', @key) Parameter Name:
      DataExtensionName Parameter Ordinal: 1 Invalid Content: set @fname =
      Lookup ('shoppers', 'first_name', 'id', @key) There is an error in
      your email. Please contact your customer service representative. Error
      1: Script SET Statement Invalid An error occurred when attempting to
      resolve a script expression. See inner exception for detail. Script
      Expression: Lookup ('shoppers', 'first_name', 'id', @key) MemberID:
      100012513 JobID: 0 The Data Extension name for a Lookup function call
      is invalid. A Data Extension of this name does not exist. Data
      Extension Name: shoppers Function Call: Lookup ('shoppers',
      'first_name', 'id', @key) Parameter Name: DataExtensionName Parameter
      Ordinal: 1 Invalid Content: set @fname = Lookup ('shoppers',
      'first_name', 'id', @key)








      marketing-cloud ampscript journeybuilder sfmc-business-unit






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked 3 hours ago









      Nate HarrisNate Harris

      8611




      8611




















          1 Answer
          1






          active

          oldest

          votes


















          2














          Any DE that is in the shared folder is "owned" by the EID (Parent MID) If you need to access it within a child BU you need to use the ENT. prefix.



          You need to update your ampscript to the following:



          %%[
          set @key = [id]
          set @fname = Lookup ('ent.shoppers', 'first_name', 'id', @key)
          ]%%





          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%2f262226%2fampscript-lookup-from-child-business-unit%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









            2














            Any DE that is in the shared folder is "owned" by the EID (Parent MID) If you need to access it within a child BU you need to use the ENT. prefix.



            You need to update your ampscript to the following:



            %%[
            set @key = [id]
            set @fname = Lookup ('ent.shoppers', 'first_name', 'id', @key)
            ]%%





            share|improve this answer





























              2














              Any DE that is in the shared folder is "owned" by the EID (Parent MID) If you need to access it within a child BU you need to use the ENT. prefix.



              You need to update your ampscript to the following:



              %%[
              set @key = [id]
              set @fname = Lookup ('ent.shoppers', 'first_name', 'id', @key)
              ]%%





              share|improve this answer



























                2












                2








                2







                Any DE that is in the shared folder is "owned" by the EID (Parent MID) If you need to access it within a child BU you need to use the ENT. prefix.



                You need to update your ampscript to the following:



                %%[
                set @key = [id]
                set @fname = Lookup ('ent.shoppers', 'first_name', 'id', @key)
                ]%%





                share|improve this answer















                Any DE that is in the shared folder is "owned" by the EID (Parent MID) If you need to access it within a child BU you need to use the ENT. prefix.



                You need to update your ampscript to the following:



                %%[
                set @key = [id]
                set @fname = Lookup ('ent.shoppers', 'first_name', 'id', @key)
                ]%%






                share|improve this answer














                share|improve this answer



                share|improve this answer








                edited 3 hours ago

























                answered 3 hours ago









                EazyEEazyE

                4129




                4129



























                    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%2f262226%2fampscript-lookup-from-child-business-unit%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

                    Canceling a color specificationRandomly assigning color to Graphics3D objects?Default color for Filling in Mathematica 9Coloring specific elements of sets with a prime modified order in an array plotHow to pick a color differing significantly from the colors already in a given color list?Detection of the text colorColor numbers based on their valueCan color schemes for use with ColorData include opacity specification?My dynamic color schemes

                    Invision Community Contents History See also References External links Navigation menuProprietaryinvisioncommunity.comIPS Community ForumsIPS Community Forumsthis blog entry"License Changes, IP.Board 3.4, and the Future""Interview -- Matt Mecham of Ibforums""CEO Invision Power Board, Matt Mecham Is a Liar, Thief!"IPB License Explanation 1.3, 1.3.1, 2.0, and 2.1ArchivedSecurity Fixes, Updates And Enhancements For IPB 1.3.1Archived"New Demo Accounts - Invision Power Services"the original"New Default Skin"the original"Invision Power Board 3.0.0 and Applications Released"the original"Archived copy"the original"Perpetual licenses being done away with""Release Notes - Invision Power Services""Introducing: IPS Community Suite 4!"Invision Community Release Notes

                    199年 目錄 大件事 到箇年出世嗰人 到箇年死嗰人 節慶、風俗習慣 導覽選單