topic Re: How to pick partial data match in QlikView https://community.qlik.com/t5/QlikView/How-to-pick-partial-data-match/m-p/1609862#M736818 <P>Can you please elaborate on what your goal is?&nbsp; I understand you're looking for a way for Qlikview to identify a partial match in Table 1 and look for it in Table 2, but then what would you like to happen?</P> <P>Thanks,<BR />Josh</P> <P>Qlik Support</P> Tue, 06 Aug 2019 14:23:14 GMT Josh_Berg_Support 2019-08-06T14:23:14Z How to pick partial data match https://community.qlik.com/t5/QlikView/How-to-pick-partial-data-match/m-p/1608084#M736816 <DIV>How to fetch data from Table 2 if there is a keyword/partial match in comparison with Table 1 ?&nbsp;</DIV> <DIV>&nbsp;</DIV> <DIV> <DIV> <P><STRONG><SPAN>Table 1 </SPAN></STRONG></P> <P><SPAN>ALIBABA</SPAN></P> <P><SPAN>AMAZON</SPAN></P> <P><SPAN>APPLE</SPAN></P> <P><SPAN>BAIDU</SPAN></P> <P><SPAN>DropBox</SPAN></P> <P><SPAN>EBAY</SPAN></P> <P>&nbsp;</P> <P><SPAN><STRONG>Table 2</STRONG></SPAN></P> <P><SPAN>ALIBABACOMINC</SPAN></P> <P><SPAN>AMAZONCOMINC</SPAN></P> <P><SPAN>AMAZONCOMINCUS</SPAN></P> <P><SPAN>APPLECANADAINC</SPAN></P> <P><SPAN>APPLEINC</SPAN></P> <P><SPAN>BAIDUUSALLCUS</SPAN></P> <P><SPAN>DropBox&nbsp;</SPAN></P> <P><SPAN>DROPBOXINCWW</SPAN></P> <P><SPAN>EBAY</SPAN></P> </DIV> </DIV> Sat, 16 Nov 2024 02:51:30 GMT https://community.qlik.com/t5/QlikView/How-to-pick-partial-data-match/m-p/1608084#M736816 SandeepMK 2024-11-16T02:51:30Z Re: How to pick partial data match https://community.qlik.com/t5/QlikView/How-to-pick-partial-data-match/m-p/1609862#M736818 <P>Can you please elaborate on what your goal is?&nbsp; I understand you're looking for a way for Qlikview to identify a partial match in Table 1 and look for it in Table 2, but then what would you like to happen?</P> <P>Thanks,<BR />Josh</P> <P>Qlik Support</P> Tue, 06 Aug 2019 14:23:14 GMT https://community.qlik.com/t5/QlikView/How-to-pick-partial-data-match/m-p/1609862#M736818 Josh_Berg_Support 2019-08-06T14:23:14Z Re: How to pick partial data match https://community.qlik.com/t5/QlikView/How-to-pick-partial-data-match/m-p/1610308#M736819 <P>You could use a mapping with mapsubstring() for it.</P><P>- Marcus</P> Wed, 07 Aug 2019 14:33:39 GMT https://community.qlik.com/t5/QlikView/How-to-pick-partial-data-match/m-p/1610308#M736819 marcus_sommer 2019-08-07T14:33:39Z