<?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 How to JOIN Direct Discovery data with table in memory as described in in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/How-to-JOIN-Direct-Discovery-data-with-table-in-memory-as/m-p/910119#M316011</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi guys I need help to understand the syntax for joining Direct discovery data with a table in memory, I can't really figure it out since I'm new to qlik. I have searched the forum, but can't find any example only a couple of unanswered posts. I can join two tables when I use the same data connection but I can't get it to work with two or more data connections. Here is a quote and a picture from the Direct Discovery technical addendum that may be of help:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;BLOCKQUOTE&gt;&lt;TABLE border="1"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD&gt;
&lt;P&gt;"The direct discovery data can be joined with the in-memory data with the common field&lt;/P&gt;
&lt;P&gt;names (Figure 3). In this example, Territory, Customer and SalesPerson tables are loaded in&lt;/P&gt;
&lt;P&gt;memory and joined to the direct discovery data via various dimension fields. This allows the&lt;/P&gt;
&lt;P&gt;user to associatively navigate both on the direct discovery and in memory data sets."&lt;/P&gt;

&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;/BLOCKQUOTE&gt;&lt;P style="padding-left: 30px;"&gt;&lt;IMG __jive_id="93657" alt="DD_join.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/93657_DD_join.png" style="height: 194px; width: 620px;" /&gt;&lt;/P&gt;&lt;P style="padding-left: 30px;"&gt;&lt;/P&gt;&lt;P style="padding-left: 30px;"&gt;Thanks!&lt;/P&gt;&lt;P style="padding-left: 30px;"&gt;//Sahir&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 22 Jul 2015 14:54:33 GMT</pubDate>
    <dc:creator />
    <dc:date>2015-07-22T14:54:33Z</dc:date>
    <item>
      <title>How to JOIN Direct Discovery data with table in memory as described in</title>
      <link>https://community.qlik.com/t5/QlikView/How-to-JOIN-Direct-Discovery-data-with-table-in-memory-as/m-p/910119#M316011</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi guys I need help to understand the syntax for joining Direct discovery data with a table in memory, I can't really figure it out since I'm new to qlik. I have searched the forum, but can't find any example only a couple of unanswered posts. I can join two tables when I use the same data connection but I can't get it to work with two or more data connections. Here is a quote and a picture from the Direct Discovery technical addendum that may be of help:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;BLOCKQUOTE&gt;&lt;TABLE border="1"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD&gt;
&lt;P&gt;"The direct discovery data can be joined with the in-memory data with the common field&lt;/P&gt;
&lt;P&gt;names (Figure 3). In this example, Territory, Customer and SalesPerson tables are loaded in&lt;/P&gt;
&lt;P&gt;memory and joined to the direct discovery data via various dimension fields. This allows the&lt;/P&gt;
&lt;P&gt;user to associatively navigate both on the direct discovery and in memory data sets."&lt;/P&gt;

&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;/BLOCKQUOTE&gt;&lt;P style="padding-left: 30px;"&gt;&lt;IMG __jive_id="93657" alt="DD_join.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/93657_DD_join.png" style="height: 194px; width: 620px;" /&gt;&lt;/P&gt;&lt;P style="padding-left: 30px;"&gt;&lt;/P&gt;&lt;P style="padding-left: 30px;"&gt;Thanks!&lt;/P&gt;&lt;P style="padding-left: 30px;"&gt;//Sahir&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 22 Jul 2015 14:54:33 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/How-to-JOIN-Direct-Discovery-data-with-table-in-memory-as/m-p/910119#M316011</guid>
      <dc:creator />
      <dc:date>2015-07-22T14:54:33Z</dc:date>
    </item>
  </channel>
</rss>

