topic Re: How to compare 2 text fields ? in QlikView https://community.qlik.com/t5/QlikView/How-to-compare-2-text-fields/m-p/559073#M1147631 <HTML><HEAD></HEAD><BODY><P>use SubStringCount() function.</P></BODY></HTML> Wed, 10 Jul 2013 07:51:52 GMT tresB 2013-07-10T07:51:52Z How to compare 2 text fields ? https://community.qlik.com/t5/QlikView/How-to-compare-2-text-fields/m-p/559072#M1147630 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Hi</SPAN></P><P><SPAN style="font-size: 10pt;"> </SPAN></P><P><SPAN style="font-size: 10pt;">I need to compare 2 text fields in 2 different tables.</SPAN></P><P><SPAN style="font-size: 10pt;"> </SPAN></P><P><SPAN style="font-size: 10pt;">One field I load from official UN Sanction list, the other one I load from my ERP masterdata.</SPAN></P><P><SPAN style="font-size: 8pt;">&nbsp;&nbsp; </SPAN></P><P><SPAN style="font-size: 10pt;">I need to compare field "name" with "Name".</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">If any part of string in "name" is found in "Name", a flag should show 1.</SPAN></P><P></P><P></P><P><SPAN style="font-size: 10pt;">I do attach a sample with inline tables. I would be happy if anyone can help me how to solve this.</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">regards</SPAN></P><P><SPAN style="font-size: 10pt;">Joerg</SPAN></P></BODY></HTML> Wed, 10 Jul 2013 07:32:27 GMT https://community.qlik.com/t5/QlikView/How-to-compare-2-text-fields/m-p/559072#M1147630 omyahamburg 2013-07-10T07:32:27Z Re: How to compare 2 text fields ? https://community.qlik.com/t5/QlikView/How-to-compare-2-text-fields/m-p/559073#M1147631 <HTML><HEAD></HEAD><BODY><P>use SubStringCount() function.</P></BODY></HTML> Wed, 10 Jul 2013 07:51:52 GMT https://community.qlik.com/t5/QlikView/How-to-compare-2-text-fields/m-p/559073#M1147631 tresB 2013-07-10T07:51:52Z Re: How to compare 2 text fields ? https://community.qlik.com/t5/QlikView/How-to-compare-2-text-fields/m-p/559074#M1147632 <HTML><HEAD></HEAD><BODY><P>Please as i am getting below message when trying to post new message</P><P></P><P id="jive-body-intro-content"></P><H1>Start New Discussion </H1><P></P><P></P><P></P><P id="jive-moderated-message">Please note, your discussion will need to be approved by a moderator before it will be viewable by others. </P><P>&nbsp; </P><P id="jive-body-main">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <UL><LI>Go to: <A _jive_internal="true" href="https://community.qlik.com/community/development">The space you posted in</A> </LI><LI>Go to: <A _jive_internal="true" href="https://community.qlik.com/index.jspa" id="jive-main-community">The main space page</A> </LI></UL>&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Wed, 10 Jul 2013 08:16:31 GMT https://community.qlik.com/t5/QlikView/How-to-compare-2-text-fields/m-p/559074#M1147632 2013-07-10T08:16:31Z