topic Re: How to match concatenated string in a column in QlikView https://community.qlik.com/t5/QlikView/How-to-match-concatenated-string-in-a-column/m-p/11237#M1792 <HTML><HEAD></HEAD><BODY><P>use if statement</P></BODY></HTML> Mon, 29 Jan 2018 09:59:34 GMT arvind1494 2018-01-29T09:59:34Z How to match concatenated string in a column https://community.qlik.com/t5/QlikView/How-to-match-concatenated-string-in-a-column/m-p/11236#M1791 <HTML><HEAD></HEAD><BODY><P>Dear All</P><P></P><P>I have a column -&nbsp; 'Code' . It has values like the attached screenshot. There are multiple codes in a single record field.</P><P>I want to check these codes against a mapping sheet and if the code matches between the field and mapping sheet it returns true else false.</P><P></P><P>Eg)&nbsp; BOM-HYD/BLR-BOM.&nbsp;&nbsp; is one of the record in the column.&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF either of BOM or HYD or BLR is available in mapping sheet then it should return TRUE. If not false. </P><P></P><P>Is it possible to search the records in above way. Kindly help me.</P><P></P><P></P><P>Thanks &amp; Regards</P><P>Chintan </P></BODY></HTML> Mon, 29 Jan 2018 09:57:40 GMT https://community.qlik.com/t5/QlikView/How-to-match-concatenated-string-in-a-column/m-p/11236#M1791 Anonymous 2018-01-29T09:57:40Z Re: How to match concatenated string in a column https://community.qlik.com/t5/QlikView/How-to-match-concatenated-string-in-a-column/m-p/11237#M1792 <HTML><HEAD></HEAD><BODY><P>use if statement</P></BODY></HTML> Mon, 29 Jan 2018 09:59:34 GMT https://community.qlik.com/t5/QlikView/How-to-match-concatenated-string-in-a-column/m-p/11237#M1792 arvind1494 2018-01-29T09:59:34Z Re: How to match concatenated string in a column https://community.qlik.com/t5/QlikView/How-to-match-concatenated-string-in-a-column/m-p/11238#M1793 <HTML><HEAD></HEAD><BODY><P>Its not working.. </P></BODY></HTML> Mon, 29 Jan 2018 10:20:50 GMT https://community.qlik.com/t5/QlikView/How-to-match-concatenated-string-in-a-column/m-p/11238#M1793 Anonymous 2018-01-29T10:20:50Z