<?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: Enrichment with Table with non existent data in Adobe Campaign Classic Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/enrichment-with-table-with-non-existent-data/m-p/461948#M15746</link>
    <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="15740006"&gt;&lt;/LI-USER&gt;&amp;nbsp;,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;What I am facing is now, if I try to add an output column from external table, it works like inner join and if no column is added all the records are shown ( like Outer Join )&lt;/P&gt;&lt;P&gt;I am at total loss, where is the issue&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dipendu_g_1-1658335420616.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/43348i6DF1D52A5D4111A8/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="dipendu_g_1-1658335420616.png" alt="dipendu_g_1-1658335420616.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dipendu_g_2-1658335704044.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/43349iEBADD2AD48EE67E0/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="dipendu_g_2-1658335704044.png" alt="dipendu_g_2-1658335704044.png" /&gt;&lt;/span&gt;&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>Wed, 20 Jul 2022 16:49:08 GMT</pubDate>
    <dc:creator>dipendu_g</dc:creator>
    <dc:date>2022-07-20T16:49:08Z</dc:date>
    <item>
      <title>Enrichment with Table with non existent data</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/enrichment-with-table-with-non-existent-data/m-p/461890#M15739</link>
      <description>&lt;P&gt;Hello All,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I am getting a list of Recipients from the query in the workflow activity.&lt;/P&gt;&lt;P&gt;What I need to do is take the ISO value of the Recipient Location and Query another external table to fetch some data basis the Location.&lt;/P&gt;&lt;P&gt;i.e if Recipient Location ISOValue = External Table ISOValue, then fetch another column from external table&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Here the issue is Recipient Location might have few values, which need not be present in the external table. In those case I need the column value to be blank or null ( Like an external Join )&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;When I use enrichment, -&amp;gt; Additional Data and Simple Join, it doesn't list those records not present in External Table, ( behaves like a inner join )&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;What should be the best method to fetch both existent and non existent data ( blank/null) from the external table&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;&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>Wed, 20 Jul 2022 12:19:52 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/enrichment-with-table-with-non-existent-data/m-p/461890#M15739</guid>
      <dc:creator>dipendu_g</dc:creator>
      <dc:date>2022-07-20T12:19:52Z</dc:date>
    </item>
    <item>
      <title>Re: Enrichment with Table with non existent data</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/enrichment-with-table-with-non-existent-data/m-p/461892#M15740</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="13913383"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;In the Enrichment, when you select the type of link, you have the choice to set the cardinality of the link you define, in your case you have to select 0-1 cardinality&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Denis_Bozonnet_0-1658319766659.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/43339iDB58BB0E8CFE4508/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="Denis_Bozonnet_0-1658319766659.png" alt="Denis_Bozonnet_0-1658319766659.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Hope this helps,&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;P&gt;Denis&lt;/P&gt;</description>
      <pubDate>Wed, 20 Jul 2022 12:23:04 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/enrichment-with-table-with-non-existent-data/m-p/461892#M15740</guid>
      <dc:creator>Denis_Bozonnet</dc:creator>
      <dc:date>2022-07-20T12:23:04Z</dc:date>
    </item>
    <item>
      <title>Re: Enrichment with Table with non existent data</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/enrichment-with-table-with-non-existent-data/m-p/461898#M15741</link>
      <description>&lt;P&gt;&lt;LI-USER uid="15740006"&gt;&lt;/LI-USER&gt;&amp;nbsp;, I had tried that, still its not working. It works like a inner join only&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>Wed, 20 Jul 2022 12:34:11 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/enrichment-with-table-with-non-existent-data/m-p/461898#M15741</guid>
      <dc:creator>dipendu_g</dc:creator>
      <dc:date>2022-07-20T12:34:11Z</dc:date>
    </item>
    <item>
      <title>Re: Enrichment with Table with non existent data</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/enrichment-with-table-with-non-existent-data/m-p/461902#M15742</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="13913383"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Could you share the screen shot of your Enrichment activity, all screens, something is wrong because it does work all the time. Are you sure the data type of the fields used by the join is the same?&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;P&gt;Denis&lt;/P&gt;</description>
      <pubDate>Wed, 20 Jul 2022 12:45:11 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/enrichment-with-table-with-non-existent-data/m-p/461902#M15742</guid>
      <dc:creator>Denis_Bozonnet</dc:creator>
      <dc:date>2022-07-20T12:45:11Z</dc:date>
    </item>
    <item>
      <title>Re: Enrichment with Table with non existent data</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/enrichment-with-table-with-non-existent-data/m-p/461948#M15746</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="15740006"&gt;&lt;/LI-USER&gt;&amp;nbsp;,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;What I am facing is now, if I try to add an output column from external table, it works like inner join and if no column is added all the records are shown ( like Outer Join )&lt;/P&gt;&lt;P&gt;I am at total loss, where is the issue&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dipendu_g_1-1658335420616.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/43348i6DF1D52A5D4111A8/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="dipendu_g_1-1658335420616.png" alt="dipendu_g_1-1658335420616.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dipendu_g_2-1658335704044.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/43349iEBADD2AD48EE67E0/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="dipendu_g_2-1658335704044.png" alt="dipendu_g_2-1658335704044.png" /&gt;&lt;/span&gt;&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>Wed, 20 Jul 2022 16:49:08 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/enrichment-with-table-with-non-existent-data/m-p/461948#M15746</guid>
      <dc:creator>dipendu_g</dc:creator>
      <dc:date>2022-07-20T16:49:08Z</dc:date>
    </item>
    <item>
      <title>Re: Enrichment with Table with non existent data</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/enrichment-with-table-with-non-existent-data/m-p/540254#M15878</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="15740006"&gt;&lt;/LI-USER&gt;,&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Could you please help&amp;nbsp;&lt;LI-USER uid="13913383"&gt;&lt;/LI-USER&gt;&amp;nbsp;further here?&lt;/P&gt;
&lt;P&gt;Thanks!&lt;/P&gt;</description>
      <pubDate>Wed, 10 Aug 2022 08:44:02 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/enrichment-with-table-with-non-existent-data/m-p/540254#M15878</guid>
      <dc:creator>Sukrity_Wadhwa</dc:creator>
      <dc:date>2022-08-10T08:44:02Z</dc:date>
    </item>
  </channel>
</rss>

