<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Lookup on an different table to fetch data in Adobe Campaign Classic Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/459938#M15619</link>
    <description>&lt;P&gt;Hi &lt;LI-USER uid="13913383"&gt;&lt;/LI-USER&gt; ,&lt;/P&gt;&lt;P&gt;If you send the email from the workflow, and don't need to keep the datas after the sending, you can use temporary datas, from the workflow, with the next syntax :&lt;/P&gt;&lt;PRE&gt;&amp;lt;%= targetData.mydata %&amp;gt;&lt;/PRE&gt;&lt;P&gt;where "myData" is the name of the data in the workflow (you can use alias into the query or enrich activity, for more convenient manipulation).&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Cedric&lt;/P&gt;</description>
    <pubDate>Thu, 07 Jul 2022 13:01:58 GMT</pubDate>
    <dc:creator>CedricRey</dc:creator>
    <dc:date>2022-07-07T13:01:58Z</dc:date>
    <item>
      <title>Lookup on an different table to fetch data</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/459838#M15601</link>
      <description>&lt;P&gt;Hi All,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;In a workflow, that I have created to send emails, I get the initial data from an external table, which I enrich with the ACC Recipients table. After the enrichment, I get the "Country" of the contacts, which is need to query on another external table, which will give me the value against each contact. This value along with other recipients value, I need to be present in the Email Delivery, that I send next.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The issue is if I add another enrichment after the Recipient enrichment, I get the value but the Delivery fails as it expects Recipient Schema.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Can you please suggest some solution to achieve this, where I can fetch the hash value, and also send the delivery&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;DG&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 07 Jul 2022 04:21:33 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/459838#M15601</guid>
      <dc:creator>dipendu_g</dc:creator>
      <dc:date>2022-07-07T04:21:33Z</dc:date>
    </item>
    <item>
      <title>Re: Lookup on an different table to fetch data</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/459840#M15602</link>
      <description>&lt;P&gt;Hello&amp;nbsp;&lt;LI-USER uid="13913383"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;You can use the change dimension activity to use the recipient schema for delivery,&lt;/P&gt;</description>
      <pubDate>Thu, 07 Jul 2022 04:49:08 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/459840#M15602</guid>
      <dc:creator>Manoj_Kumar_</dc:creator>
      <dc:date>2022-07-07T04:49:08Z</dc:date>
    </item>
    <item>
      <title>Re: Lookup on an different table to fetch data</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/459856#M15608</link>
      <description>&lt;P&gt;The Recipient Schema is not showing up in the Change Dimension Activity&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;DG&lt;/P&gt;</description>
      <pubDate>Thu, 07 Jul 2022 06:30:29 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/459856#M15608</guid>
      <dc:creator>dipendu_g</dc:creator>
      <dc:date>2022-07-07T06:30:29Z</dc:date>
    </item>
    <item>
      <title>Re: Lookup on an different table to fetch data</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/459857#M15609</link>
      <description>&lt;P&gt;Then you will have to use the enrichment activity to reconcile the data with the recipient on the basis of your email or another identifier.&lt;/P&gt;</description>
      <pubDate>Thu, 07 Jul 2022 06:32:25 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/459857#M15609</guid>
      <dc:creator>Manoj_Kumar_</dc:creator>
      <dc:date>2022-07-07T06:32:25Z</dc:date>
    </item>
    <item>
      <title>Re: Lookup on an different table to fetch data</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/459868#M15611</link>
      <description>&lt;P&gt;Hi Manoj,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Step 1 - Gettig Data from External Table&lt;/P&gt;&lt;P&gt;Step 2 - Enriching with Recipient&lt;/P&gt;&lt;P&gt;Step 3 - Using Recipient country to fetch data from another table (external)&lt;/P&gt;&lt;P&gt;Step 4 - Change Dimension to revert back targeting dimension to Recipient - ( I am unable tp see the Recipient dimesnion here )&lt;/P&gt;&lt;P&gt;Step 5 - Email Delivery&lt;/P&gt;&lt;P&gt;If you see, I am enriching the data on Step 3, again, I need to enrich back ?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;DG&lt;/P&gt;</description>
      <pubDate>Thu, 07 Jul 2022 07:21:58 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/459868#M15611</guid>
      <dc:creator>dipendu_g</dc:creator>
      <dc:date>2022-07-07T07:21:58Z</dc:date>
    </item>
    <item>
      <title>Re: Lookup on an different table to fetch data</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/459869#M15612</link>
      <description>&lt;P&gt;&lt;LI-USER uid="13913383"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;You already have the recipient from the enrichment from step 2. Where did that go in the next steps?&lt;/P&gt;</description>
      <pubDate>Thu, 07 Jul 2022 07:23:49 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/459869#M15612</guid>
      <dc:creator>Manoj_Kumar_</dc:creator>
      <dc:date>2022-07-07T07:23:49Z</dc:date>
    </item>
    <item>
      <title>Re: Lookup on an different table to fetch data</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/459889#M15613</link>
      <description>&lt;P&gt;On Step 2, When I enrich my Targeting Dimension is now Recipient. After that when I enrich again, the TD changes to that Table.&lt;/P&gt;&lt;P&gt;But in Change Dimension, I am unable to go back to the Recipient TD&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Hope, I could understand your question and answer it&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;DG&lt;/P&gt;</description>
      <pubDate>Thu, 07 Jul 2022 09:51:20 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/459889#M15613</guid>
      <dc:creator>dipendu_g</dc:creator>
      <dc:date>2022-07-07T09:51:20Z</dc:date>
    </item>
    <item>
      <title>Re: Lookup on an different table to fetch data</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/459938#M15619</link>
      <description>&lt;P&gt;Hi &lt;LI-USER uid="13913383"&gt;&lt;/LI-USER&gt; ,&lt;/P&gt;&lt;P&gt;If you send the email from the workflow, and don't need to keep the datas after the sending, you can use temporary datas, from the workflow, with the next syntax :&lt;/P&gt;&lt;PRE&gt;&amp;lt;%= targetData.mydata %&amp;gt;&lt;/PRE&gt;&lt;P&gt;where "myData" is the name of the data in the workflow (you can use alias into the query or enrich activity, for more convenient manipulation).&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Cedric&lt;/P&gt;</description>
      <pubDate>Thu, 07 Jul 2022 13:01:58 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/459938#M15619</guid>
      <dc:creator>CedricRey</dc:creator>
      <dc:date>2022-07-07T13:01:58Z</dc:date>
    </item>
    <item>
      <title>Re: Lookup on an different table to fetch data</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/460035#M15624</link>
      <description>&lt;P&gt;Hi Cedric,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have an external table with the following columns&lt;/P&gt;&lt;TABLE width="287"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD width="115"&gt;Contact Mail&lt;/TD&gt;&lt;TD width="100"&gt;Institution&lt;/TD&gt;&lt;TD width="72"&gt;Score&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;aa@bb.com&lt;/TD&gt;&lt;TD&gt;Institution 1&lt;/TD&gt;&lt;TD&gt;50&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;aa1@bb.com&lt;/TD&gt;&lt;TD&gt;Institution 1&lt;/TD&gt;&lt;TD&gt;75&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;aa2@bb.com&lt;/TD&gt;&lt;TD&gt;Institution 2&lt;/TD&gt;&lt;TD&gt;85&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;In Step 2 I enrich this with Recipients to get the Country&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;This country I need to lookup on another external table to fetch the url,&amp;nbsp;&lt;/P&gt;&lt;TABLE width="264"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD width="82.9972px"&gt;Country&lt;/TD&gt;&lt;TD width="180.007px"&gt;Url&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="82.9972px"&gt;Australia&lt;/TD&gt;&lt;TD width="180.007px"&gt;&lt;A href="https://xxx.yyy.com#aus" target="_blank"&gt;https://xxx.yyy.com#aus&lt;/A&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="82.9972px"&gt;New Zealand&lt;/TD&gt;&lt;TD width="180.007px"&gt;&lt;A href="https://aaa.bbb.com#nz" target="_blank"&gt;https://aaa.bbb.com#nz&lt;/A&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;In the final email, I need all the fields, contact ( to send mail ), institution, score and url&lt;/P&gt;&lt;P&gt;Request if you can tell the way to achieve the same&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;DG&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 08 Jul 2022 04:56:13 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/460035#M15624</guid>
      <dc:creator>dipendu_g</dc:creator>
      <dc:date>2022-07-08T04:56:13Z</dc:date>
    </item>
    <item>
      <title>Re: Lookup on an different table to fetch data</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/460070#M15626</link>
      <description>&lt;P&gt;Any suggestion&amp;nbsp;&lt;LI-USER uid="16614846"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;LI-USER uid="17446130"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;DG&lt;/P&gt;</description>
      <pubDate>Fri, 08 Jul 2022 08:26:16 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/460070#M15626</guid>
      <dc:creator>dipendu_g</dc:creator>
      <dc:date>2022-07-08T08:26:16Z</dc:date>
    </item>
    <item>
      <title>Re: Lookup on an different table to fetch data</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/460073#M15627</link>
      <description>&lt;P&gt;If the initial datas come from an external source (for exemple a file), as &lt;LI-USER uid="16614846"&gt;&lt;/LI-USER&gt;&amp;nbsp; said, you'll have to change the dimension to retrieve the corresponding recipients. Ensure that the "keep extra datas" is checked (2nd tab 'Result').&lt;/P&gt;&lt;P&gt;This way, you'll send email to nms:recipient (and not to targets defined in an external file). And you can use the temporary datas with the "targetData.XXX" syntax. The "XXX" must be the name of the attribute or element (and not the label) in the temporary schema in the incoming transition of the delivery activity. That's why it could be better to use aliases.&lt;/P&gt;</description>
      <pubDate>Fri, 08 Jul 2022 08:38:37 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/460073#M15627</guid>
      <dc:creator>CedricRey</dc:creator>
      <dc:date>2022-07-08T08:38:37Z</dc:date>
    </item>
    <item>
      <title>Re: Lookup on an different table to fetch data</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/460075#M15629</link>
      <description>&lt;P&gt;&lt;LI-USER uid="17446130"&gt;&lt;/LI-USER&gt;&amp;nbsp;, At what stage I need to use the CD activity. the CD activity was not identifying the Recipients for me. Will you be able to guide me&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;DG&lt;/P&gt;</description>
      <pubDate>Fri, 08 Jul 2022 08:42:17 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/460075#M15629</guid>
      <dc:creator>dipendu_g</dc:creator>
      <dc:date>2022-07-08T08:42:17Z</dc:date>
    </item>
    <item>
      <title>Re: Lookup on an different table to fetch data</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/460084#M15634</link>
      <description>&lt;P&gt;After the "Enrich" when you retrieve the corresponding recipient :&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="CedricRey_0-1657271452639.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/42877iEFB6D49E8A8D2C26/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="CedricRey_0-1657271452639.png" alt="CedricRey_0-1657271452639.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="CedricRey_1-1657271476466.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/42878i416454BF08D26835/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="CedricRey_1-1657271476466.png" alt="CedricRey_1-1657271476466.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;(Sorry for the screenshot, don't have access to english instance, only french at the moment, but you should understand)&lt;/P&gt;</description>
      <pubDate>Fri, 08 Jul 2022 09:13:30 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/460084#M15634</guid>
      <dc:creator>CedricRey</dc:creator>
      <dc:date>2022-07-08T09:13:30Z</dc:date>
    </item>
    <item>
      <title>Re: Lookup on an different table to fetch data</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/460088#M15635</link>
      <description>&lt;P&gt;Hi Cedric,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Sorry, but I am unable to get this screen.&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dipendu_g_0-1657272722983.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/42879i893BBFE587904A39/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="dipendu_g_0-1657272722983.png" alt="dipendu_g_0-1657272722983.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I am unable to see this&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;DG&lt;/P&gt;</description>
      <pubDate>Fri, 08 Jul 2022 09:32:29 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/460088#M15635</guid>
      <dc:creator>dipendu_g</dc:creator>
      <dc:date>2022-07-08T09:32:29Z</dc:date>
    </item>
    <item>
      <title>Re: Lookup on an different table to fetch data</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/460090#M15636</link>
      <description>&lt;P&gt;Hi Cedric,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I got it now. Thanks a lot to help me and show me the screenshot.&lt;/P&gt;&lt;P&gt;Really appreciate&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;DG&lt;/P&gt;</description>
      <pubDate>Fri, 08 Jul 2022 09:57:28 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/lookup-on-an-different-table-to-fetch-data/m-p/460090#M15636</guid>
      <dc:creator>dipendu_g</dc:creator>
      <dc:date>2022-07-08T09:57:28Z</dc:date>
    </item>
  </channel>
</rss>

