topic Re: Multiple tables with only three fields in common in QlikView https://community.qlik.com/t5/QlikView/Multiple-tables-with-only-three-fields-in-common/m-p/621167#M1101510 <HTML><HEAD></HEAD><BODY><P>If Key is unique then make join between 2 tables based on Key.</P></BODY></HTML> Wed, 09 Apr 2014 19:02:05 GMT its_anandrjs 2014-04-09T19:02:05Z Multiple tables with only three fields in common https://community.qlik.com/t5/QlikView/Multiple-tables-with-only-three-fields-in-common/m-p/621165#M1101508 <HTML><HEAD></HEAD><BODY><P>I am creating a QV document using tables from the US Census Bureau.&nbsp; All the the tables have three fields in common (ID, ID2 and Geography).&nbsp; I have a "Main Data" table and trying to connect it to the other tables.&nbsp; However, with only those three fields in common it seems there are no other unique fields by which to associate them.&nbsp; I have created one unique key (ID &amp; '|' &amp; ID2 &amp; '|' &amp; Geography as [%Key Field]), but that only links two tables together and leaves the others without a unique key by which to link them.&nbsp; Any thoughts?</P></BODY></HTML> Wed, 09 Apr 2014 18:43:23 GMT https://community.qlik.com/t5/QlikView/Multiple-tables-with-only-three-fields-in-common/m-p/621165#M1101508 2014-04-09T18:43:23Z Re: Multiple tables with only three fields in common https://community.qlik.com/t5/QlikView/Multiple-tables-with-only-three-fields-in-common/m-p/621166#M1101509 <HTML><HEAD></HEAD><BODY><P>Actually I figured it out on my own.&nbsp; I just needed to use a JOIN.</P></BODY></HTML> Wed, 09 Apr 2014 18:57:38 GMT https://community.qlik.com/t5/QlikView/Multiple-tables-with-only-three-fields-in-common/m-p/621166#M1101509 2014-04-09T18:57:38Z Re: Multiple tables with only three fields in common https://community.qlik.com/t5/QlikView/Multiple-tables-with-only-three-fields-in-common/m-p/621167#M1101510 <HTML><HEAD></HEAD><BODY><P>If Key is unique then make join between 2 tables based on Key.</P></BODY></HTML> Wed, 09 Apr 2014 19:02:05 GMT https://community.qlik.com/t5/QlikView/Multiple-tables-with-only-three-fields-in-common/m-p/621167#M1101510 its_anandrjs 2014-04-09T19:02:05Z