topic %Key field link tables in QlikView https://community.qlik.com/t5/QlikView/Key-field-link-tables/m-p/1340379#M619387 <HTML><HEAD></HEAD><BODY><P>I am trying to connect two tables and the data is not a one to one connection.</P><P></P><P>Table one is structured as so:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Job#</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Quote</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Quote Cost</STRONG></TH></TR><TR><TD>12345, 12346</TD><TD>500</TD><TD>$10,000</TD></TR><TR><TD>12347</TD><TD>300</TD><TD>$7,000</TD></TR></TBODY></TABLE><P></P><P>Table Two is structured as:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Job#</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Actual Hours</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Actual Cost</STRONG></TH></TR><TR><TD>12345</TD><TD>550</TD><TD>$11,000</TD></TR><TR><TD><SPAN style="font-size: 13.3333px;">12346</SPAN></TD><TD>520</TD><TD>$10,500</TD></TR><TR><TD>12347</TD><TD>200</TD><TD>$6,000</TD></TR></TBODY></TABLE><P></P><P></P><P>Is there a way to make The Jobs 12345 and 12346 with the , separator link to two different lines so I can pull the Quote values to compare?</P><P></P><P>Thank you.&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Fri, 12 May 2017 22:59:03 GMT Anonymous 2017-05-12T22:59:03Z %Key field link tables https://community.qlik.com/t5/QlikView/Key-field-link-tables/m-p/1340379#M619387 <HTML><HEAD></HEAD><BODY><P>I am trying to connect two tables and the data is not a one to one connection.</P><P></P><P>Table one is structured as so:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Job#</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Quote</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Quote Cost</STRONG></TH></TR><TR><TD>12345, 12346</TD><TD>500</TD><TD>$10,000</TD></TR><TR><TD>12347</TD><TD>300</TD><TD>$7,000</TD></TR></TBODY></TABLE><P></P><P>Table Two is structured as:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Job#</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Actual Hours</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Actual Cost</STRONG></TH></TR><TR><TD>12345</TD><TD>550</TD><TD>$11,000</TD></TR><TR><TD><SPAN style="font-size: 13.3333px;">12346</SPAN></TD><TD>520</TD><TD>$10,500</TD></TR><TR><TD>12347</TD><TD>200</TD><TD>$6,000</TD></TR></TBODY></TABLE><P></P><P></P><P>Is there a way to make The Jobs 12345 and 12346 with the , separator link to two different lines so I can pull the Quote values to compare?</P><P></P><P>Thank you.&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Fri, 12 May 2017 22:59:03 GMT https://community.qlik.com/t5/QlikView/Key-field-link-tables/m-p/1340379#M619387 Anonymous 2017-05-12T22:59:03Z Re: %Key field link tables https://community.qlik.com/t5/QlikView/Key-field-link-tables/m-p/1340380#M619388 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>LOAD</STRONG> <STRONG>SubField(Job#, ', ') as Job#,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; Quote,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; Quote Cost</STRONG></P><P><STRONG>FROM....</STRONG></P></BODY></HTML> Fri, 12 May 2017 23:00:53 GMT https://community.qlik.com/t5/QlikView/Key-field-link-tables/m-p/1340380#M619388 sunny_talwar 2017-05-12T23:00:53Z Re: %Key field link tables https://community.qlik.com/t5/QlikView/Key-field-link-tables/m-p/1340381#M619389 <HTML><HEAD></HEAD><BODY><P>Thank you.</P></BODY></HTML> Mon, 15 May 2017 17:33:00 GMT https://community.qlik.com/t5/QlikView/Key-field-link-tables/m-p/1340381#M619389 Anonymous 2017-05-15T17:33:00Z