topic Re: JOINING Tables Issue... Please Help! in QlikView https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495826#M689411 <HTML><HEAD></HEAD><BODY><P>That means that there is not a single value in common in Institution field in both tables.&nbsp; Otherwise the original script should work.</P></BODY></HTML> Tue, 26 Nov 2013 20:59:59 GMT Anonymous 2013-11-26T20:59:59Z JOINING Tables Issue... Please Help! https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495816#M689399 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000;"><STRONG>Hello,</STRONG></SPAN></P><P><STRONG><SPAN class="s1" style="color: #000000;"><BR /></SPAN></STRONG></P><P><STRONG><SPAN class="s1" style="color: #000000;">I am trying to combine to tables as follows:</SPAN></STRONG></P><P><STRONG><SPAN class="s1" style="color: #000000;"><BR /></SPAN></STRONG></P><P><SPAN class="s1" style="color: #000000;"><STRONG>Table1 Contains:</STRONG></SPAN></P><P><SPAN class="s1" style="color: #000000;">geoid&nbsp;&nbsp;&nbsp;&nbsp; Distance&nbsp;&nbsp;&nbsp;&nbsp; Institution</SPAN></P><P><SPAN style="color: #000000;"><SPAN class="s1"></SPAN>01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a</SPAN></P><P><SPAN class="s1" style="color: #000000;">02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a</SPAN></P><P><SPAN class="s1" style="color: #000000;">03&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a</SPAN></P><P><SPAN class="s1" style="color: #000000;">01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b</SPAN></P><P><SPAN class="s1" style="color: #000000;">03&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b </SPAN></P><P><SPAN class="s1" style="color: #000000;"><BR /></SPAN></P><P><SPAN class="s1" style="color: #000000;"><STRONG>Table2 Contains:</STRONG></SPAN></P><P><SPAN class="s1" style="color: #000000;">Institution&nbsp;&nbsp;&nbsp;&nbsp; Company&nbsp;&nbsp;&nbsp;&nbsp; Program&nbsp;&nbsp;&nbsp;&nbsp; Degree</SPAN></P><P><SPAN class="s1" style="color: #000000;">a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aa&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 51&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</SPAN></P><P><SPAN class="s1" style="color: #000000;">a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aa&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 47&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</SPAN></P><P><SPAN class="s1" style="color: #000000;">a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aa&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 47&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2<BR /></SPAN></P><P><SPAN class="s1" style="color: #000000;">b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</SPAN></P><P><SPAN class="s1" style="color: #000000;">b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</SPAN></P><P><SPAN class="s1" style="color: #000000;"><BR /></SPAN></P><P><SPAN class="s1" style="color: #000000;"><STRONG>I Need the final table to look like this:</STRONG></SPAN></P><P><SPAN class="s1" style="color: #000000;">Institution&nbsp;&nbsp;&nbsp;&nbsp; Company&nbsp;&nbsp;&nbsp;&nbsp; Program&nbsp;&nbsp;&nbsp;&nbsp; Degree&nbsp;&nbsp;&nbsp;&nbsp; Geoid&nbsp;&nbsp;&nbsp;&nbsp; Distance</SPAN></P><P><SPAN class="s1" style="color: #000000;">a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aa&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 51&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</SPAN></P><P><SPAN class="s1" style="color: #000000;">a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aa&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 51&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</SPAN></P><P><SPAN class="s1" style="color: #000000;">a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aa&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 51&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 03&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6<BR /></SPAN></P><P><SPAN class="s1" style="color: #000000;">a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aa&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 47&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</SPAN></P><P><SPAN style="color: #000000;">a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aa&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 47&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</SPAN></P><P><SPAN style="color: #000000;">a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aa&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 47&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 03&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6</SPAN></P><P><SPAN style="color: #000000;">a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aa&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 47&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</SPAN></P><P><SPAN style="color: #000000;">a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aa&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 47&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</SPAN></P><P><SPAN style="color: #000000;">a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aa&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 47&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 03&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6</SPAN></P><P><SPAN class="s1" style="color: #000000;">b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</SPAN></P><P><SPAN class="s1" style="color: #000000;">b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 03&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7</SPAN></P><P><SPAN class="s1" style="color: #000000;">b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</SPAN></P><P><SPAN class="s1" style="color: #000000;">b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 03&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7</SPAN></P><P></P><P><SPAN class="s1" style="color: #000000;"><STRONG>This is the Load Script I have right now:<BR /></STRONG></SPAN></P><P><SPAN class="s1" style="color: #000000;"><STRONG><BR /></STRONG></SPAN></P><P><SPAN class="s1" style="color: #000000;"><STRONG>Table1:<BR /></STRONG></SPAN></P><P><SPAN style="color: #000000;"><SPAN class="s1"><STRONG>LOAD</STRONG></SPAN> <SPAN class="s2">geoid</SPAN>, </SPAN><BR /><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Distance, </SPAN><BR /><SPAN class="s2" style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Institution</SPAN><BR /><SPAN style="color: #000000;"> <SPAN class="s1">FROM </SPAN><C></C></SPAN><BR /> </P><P><SPAN style="color: #000000;"><SPAN class="s1">outer</SPAN> <SPAN class="s1">join</SPAN></SPAN><BR /> </P><P><SPAN style="color: #000000;"><STRONG>Table2:</STRONG></SPAN><BR /><SPAN style="color: #000000;"><SPAN class="s1"><STRONG>LOAD</STRONG></SPAN> <SPAN class="s2">Institution</SPAN>, </SPAN><BR /><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="s2">Company</SPAN>,</SPAN><BR /><SPAN style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="s2">Program</SPAN>, </SPAN><BR /><SPAN class="s2" style="color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Degree</SPAN><BR /><SPAN style="color: #000000;"> <SPAN class="s1">FROM </SPAN><C></C></SPAN></P><P></P><P></P><P><SPAN style="color: #000000;"><STRONG>Thanks in advance!</STRONG></SPAN></P></BODY></HTML> Tue, 26 Nov 2013 20:19:02 GMT https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495816#M689399 zach_paz 2013-11-26T20:19:02Z Re: JOINING Tables Issue... Please Help! https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495817#M689401 <HTML><HEAD></HEAD><BODY><P><STRONG>Zach</STRONG></P><P></P><P>Both your load statements reference the same source xlsx, as in:</P><P><SPAN class="s1" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">&nbsp;&nbsp;&nbsp;&nbsp; FROM </SPAN><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><C></C></SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P>Is that a typo in your post or the cause of your problem ?</P><P></P><P></P><P>Best Regards,&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Bill</STRONG></P></BODY></HTML> Tue, 26 Nov 2013 20:24:21 GMT https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495817#M689401 Anonymous 2013-11-26T20:24:21Z Re: JOINING Tables Issue... Please Help! https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495818#M689403 <HTML><HEAD></HEAD><BODY><P>that is a typo... they are from two different tabs in an excel document</P></BODY></HTML> Tue, 26 Nov 2013 20:27:30 GMT https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495818#M689403 zach_paz 2013-11-26T20:27:30Z Re: JOINING Tables Issue... Please Help! https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495819#M689404 <HTML><HEAD></HEAD><BODY><P>I think you are almost there (if you address the correct source), just use the JOIN as LOAD prefix:</P><P></P><P><EM>RESULT:</EM></P><P><EM>LOAD * INLINE [</EM></P><P><EM>geoid,&nbsp;&nbsp;&nbsp;&nbsp; Distance,&nbsp;&nbsp;&nbsp;&nbsp; Institution</EM></P><P><EM>01,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a</EM></P><P><EM>02,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a</EM></P><P><EM>03,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a</EM></P><P><EM>01,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b</EM></P><P><EM>03,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b</EM></P><P><EM>];</EM></P><P></P><P></P><P><EM>JOIN (RESULT) LOAD * INLINE [</EM></P><P><EM>Institution,&nbsp;&nbsp;&nbsp;&nbsp; Company,&nbsp;&nbsp;&nbsp;&nbsp; Program ,&nbsp;&nbsp;&nbsp; Degree</EM></P><P><EM>a,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aa,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 51,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</EM></P><P><EM>a,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aa,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 47,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</EM></P><P><EM>a,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aa,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 47,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</EM></P><P><EM>b,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bb,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</EM></P><P><EM>b,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bb,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</EM></P><P><EM>];</EM></P></BODY></HTML> Tue, 26 Nov 2013 20:27:44 GMT https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495819#M689404 swuehl 2013-11-26T20:27:44Z Re: Re: JOINING Tables Issue... Please Help! https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495820#M689405 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #ff0000;">I tried this:</SPAN></P><P></P><P>Result:<BR /> <SPAN class="s1"><STRONG>LOAD</STRONG></SPAN> <SPAN class="s2">geoid</SPAN>, <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="s2">Distance</SPAN>, <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="s2">Institution</SPAN><BR /> <SPAN class="s1">FROM</SPAN><BR /> <C><BR /> (<SPAN class="s1">ooxml</SPAN>, <SPAN class="s1">embedded</SPAN> <SPAN class="s1">labels</SPAN>, <SPAN class="s1">table</SPAN> <SPAN class="s1">is</SPAN> geoid);<BR /> <BR /> <SPAN class="s1">JOIN</SPAN> (Result)</C></P><P></P><P><SPAN class="s1" style="font-size: 10pt; line-height: 1.5em;"><STRONG>LOAD</STRONG></SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;"> </SPAN><SPAN class="s2" style="font-size: 10pt; line-height: 1.5em;">Institution</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">, </SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="s2">Company</SPAN>,<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="s2">Degree</SPAN>, <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="s2">Program</SPAN><BR /> <SPAN class="s1">FROM</SPAN><BR /> <C><BR /> (<SPAN class="s1">ooxml</SPAN>, <SPAN class="s1">embedded</SPAN> <SPAN class="s1">labels</SPAN>, <SPAN class="s1">table</SPAN> <SPAN class="s1">is</SPAN> program);</C></P><P></P><P><SPAN style="color: #ff0000;">Still doesn't work. Does it matter that I am not using an "INLINE" load?</SPAN></P></BODY></HTML> Tue, 26 Nov 2013 20:37:38 GMT https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495820#M689405 zach_paz 2013-11-26T20:37:38Z Re: Re: JOINING Tables Issue... Please Help! https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495821#M689406 <HTML><HEAD></HEAD><BODY><P>What exactely do you mean with 'doesn't work'? </P><P></P><P>Error during execution, no Result table, too few lines, too many lines?</P><P>To make above work, the values in Institution in both tables need to match.</P></BODY></HTML> Tue, 26 Nov 2013 20:42:46 GMT https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495821#M689406 swuehl 2013-11-26T20:42:46Z Re: JOINING Tables Issue... Please Help! https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495822#M689407 <HTML><HEAD></HEAD><BODY><P><STRONG>Zach</STRONG></P><P></P><P>What kind of 'doesn't work' ?</P><P></P><P>Do you get an error?&nbsp; If so what ?</P><P></P><P>Do you get the wrong result data?&nbsp; If so what ?</P><P></P><P></P><P>Best Regards,&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Bill</STRONG></P></BODY></HTML> Tue, 26 Nov 2013 20:44:26 GMT https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495822#M689407 Anonymous 2013-11-26T20:44:26Z Re: JOINING Tables Issue... Please Help! https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495823#M689408 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>Try this:</P><P></P><P>T1:</P><P>LOAD geoid, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Distance, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Institution</P><P>FROM</P><P>C:\yourdoc.xlsx</P><P>(ooxml, embedded labels, table is Sheet2);</P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">T2:</SPAN></P><P><STRONG>left join (T1)</STRONG></P><P>LOAD </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Institution, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Company, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Program, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Degree</P><P>FROM</P><P>C:\yourdoc.xlsx</P><P>(ooxml, embedded labels, table is Sheet1);</P></BODY></HTML> Tue, 26 Nov 2013 20:47:03 GMT https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495823#M689408 albertovarela 2013-11-26T20:47:03Z Re: Re: JOINING Tables Issue... Please Help! https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495824#M689409 <HTML><HEAD></HEAD><BODY><P>Bill, i<SPAN style="font-size: 10pt; line-height: 1.5em;">t did not produce the result table that I am looking for.</SPAN></P></BODY></HTML> Tue, 26 Nov 2013 20:54:41 GMT https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495824#M689409 zach_paz 2013-11-26T20:54:41Z Re: Re: JOINING Tables Issue... Please Help! https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495825#M689410 <HTML><HEAD></HEAD><BODY><P>Alberto, i<SPAN style="font-size: 10pt; line-height: 1.5em;">t resulted in no data for Company, Program and Degree.</SPAN></P></BODY></HTML> Tue, 26 Nov 2013 20:56:20 GMT https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495825#M689410 zach_paz 2013-11-26T20:56:20Z Re: JOINING Tables Issue... Please Help! https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495826#M689411 <HTML><HEAD></HEAD><BODY><P>That means that there is not a single value in common in Institution field in both tables.&nbsp; Otherwise the original script should work.</P></BODY></HTML> Tue, 26 Nov 2013 20:59:59 GMT https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495826#M689411 Anonymous 2013-11-26T20:59:59Z Re: JOINING Tables Issue... Please Help! https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495827#M689412 <HTML><HEAD></HEAD><BODY><P>It would really help if you post either your input data or a more complete description of what you get (..not the table that I am looking for - is not really helpful, too).</P><P></P><P>If you don't get data for Company, Program, Degree when doing the left join, I assume your Instituion values are not matching.</P></BODY></HTML> Tue, 26 Nov 2013 21:00:15 GMT https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495827#M689412 swuehl 2013-11-26T21:00:15Z Re: JOINING Tables Issue... Please Help! https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495828#M689413 <HTML><HEAD></HEAD><BODY><P>What is your Primary Key? You have different fields in each table... You must have something similar to:</P><P></P><P>T1:</P><P>LOAD <SPAN style="text-decoration: underline;"><STRONG>geoid</STRONG></SPAN>,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Distance,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Institution</P><P>FROM</P><P>C:\yourdoc.xlsx</P><P>(ooxml, embedded labels, table is Sheet2);</P><P></P><P>outer join (T1)</P><P>LOAD <SPAN style="text-decoration: underline;"><STRONG>geoid</STRONG></SPAN>,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Institution,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Company,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Program,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Degree</P><P>FROM</P><P>C:\yourdoc.xlsx</P><P>(ooxml, embedded labels, table is Sheet1);</P></BODY></HTML> Tue, 26 Nov 2013 21:09:29 GMT https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495828#M689413 javier_florian 2013-11-26T21:09:29Z Re: JOINING Tables Issue... Please Help! https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495829#M689414 <HTML><HEAD></HEAD><BODY><P>Thank you everyone.</P><P></P><P>It turns out that <A href="https://community.qlik.com/qlik-users/15823">swuehl</A> had the adjustment I needed.. The error I was getting after I made the adjustment was because of a header typo in one of my table files.</P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">I would not survive without QV Community!</SPAN></P><P></P><P>Thanks again!</P></BODY></HTML> Tue, 26 Nov 2013 21:10:15 GMT https://community.qlik.com/t5/QlikView/JOINING-Tables-Issue-Please-Help/m-p/495829#M689414 zach_paz 2013-11-26T21:10:15Z