https://community.qlik.com/t5/App-Development/COUNTING-MATCHED-CELLS-FROM-2-SEPERATE-TABLES/m-p/1561665#M40907 Load master postal code table first and name column as postalcode which is in table 2<BR />Now, load table 2 using where exist clause.<BR />Now, using noofrows function on table2 you can get count. Wed, 27 Mar 2019 04:23:40 GMT passionate 2019-03-27T04:23:40Z https://community.qlik.com/t5/App-Development/COUNTING-MATCHED-CELLS-FROM-2-SEPERATE-TABLES/m-p/1561619#M40899 <P>Hello all,</P><P>&nbsp;</P><P>I need your support for my frustration!</P><P><STRONG>I have a TABLE1 with POSTAL CODES, and TABLE 2&nbsp; MASTER POSTAL CODES. The TABLE1 has matching Postal codes in Table 2.</STRONG></P><P>&nbsp;</P><P>I would like to count only the matching Postal codes between the two. These are separate tables, and <STRONG>there is no common field to join them</STRONG>. I tried creating a resident table but then i need to first join them at least or somehow use two residents which i dont think i know how?</P><P>&nbsp;</P><P>I really need your support.&nbsp;</P> Sat, 16 Nov 2024 21:10:27 GMT https://community.qlik.com/t5/App-Development/COUNTING-MATCHED-CELLS-FROM-2-SEPERATE-TABLES/m-p/1561619#M40899 hannahlovex 2024-11-16T21:10:27Z https://community.qlik.com/t5/App-Development/COUNTING-MATCHED-CELLS-FROM-2-SEPERATE-TABLES/m-p/1561665#M40907 Load master postal code table first and name column as postalcode which is in table 2<BR />Now, load table 2 using where exist clause.<BR />Now, using noofrows function on table2 you can get count. Wed, 27 Mar 2019 04:23:40 GMT https://community.qlik.com/t5/App-Development/COUNTING-MATCHED-CELLS-FROM-2-SEPERATE-TABLES/m-p/1561665#M40907 passionate 2019-03-27T04:23:40Z