topic SUBSET RATIO @ 0% 2 tables, Attempting a names match with no success in App Development https://community.qlik.com/t5/App-Development/SUBSET-RATIO-0-2-tables-Attempting-a-names-match-with-no-success/m-p/34888#M2349 <HTML><HEAD></HEAD><BODY><P>FIXED</P><P></P><P><SPAN style="font-size: 13.3333px;">Thanks in advance team</SPAN></P></BODY></HTML> Thu, 15 Feb 2018 20:24:00 GMT deerhunter 2018-02-15T20:24:00Z SUBSET RATIO @ 0% 2 tables, Attempting a names match with no success https://community.qlik.com/t5/App-Development/SUBSET-RATIO-0-2-tables-Attempting-a-names-match-with-no-success/m-p/34888#M2349 <HTML><HEAD></HEAD><BODY><P>FIXED</P><P></P><P><SPAN style="font-size: 13.3333px;">Thanks in advance team</SPAN></P></BODY></HTML> Thu, 15 Feb 2018 20:24:00 GMT https://community.qlik.com/t5/App-Development/SUBSET-RATIO-0-2-tables-Attempting-a-names-match-with-no-success/m-p/34888#M2349 deerhunter 2018-02-15T20:24:00Z Re: SUBSET RATIO @ 0% 2 tables, Attempting a names match with no success https://community.qlik.com/t5/App-Development/SUBSET-RATIO-0-2-tables-Attempting-a-names-match-with-no-success/m-p/34889#M2350 <HTML><HEAD></HEAD><BODY><P>What is the best way to associate a string field FullName, that was created using: </P><P>&nbsp;&nbsp;&nbsp;&nbsp; lastname, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; firstname,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Upper(Trim(lastname)) &amp; ' ' &amp; Upper(Trim(firstname)) as FullName </P><P>from two tables?</P><P>I also tried converting it to: Upper(Trim(FullName)) as FullName</P><P>&nbsp;&nbsp;&nbsp;&nbsp; within a preceding load</P><P></P><P>Resulting in no FullName matches where there should 25</P><P></P><P>Any ideas out there?</P></BODY></HTML> Mon, 26 Feb 2018 13:09:48 GMT https://community.qlik.com/t5/App-Development/SUBSET-RATIO-0-2-tables-Attempting-a-names-match-with-no-success/m-p/34889#M2350 deerhunter 2018-02-26T13:09:48Z