topic How to match two fields with almost the same content in QlikView https://community.qlik.com/t5/QlikView/How-to-match-two-fields-with-almost-the-same-content/m-p/376096#M140182 <HTML><HEAD></HEAD><BODY><P>Like will not work in this case as he needs to join the table. Like is used in a where clause</P></BODY></HTML> Fri, 30 Mar 2012 08:08:16 GMT jvitantonio 2012-03-30T08:08:16Z How to match two fields with almost the same content https://community.qlik.com/t5/QlikView/How-to-match-two-fields-with-almost-the-same-content/m-p/376093#M140179 <HTML><HEAD></HEAD><BODY><P>Hi all!</P><P></P><P>I have the following problem: I have one field showing a code and another field showing the same code with some more digits at the end or at the beginning of the field. I have to match and select the two fields independently by the more digits, for example:</P><P></P><P>field 1:&nbsp; mdfgxx2011</P><P></P><P>field 2: mdfgxx2011-32_def</P><P></P><P>or</P><P></P><P>field 2: IT_mdfgxx2011</P><P></P><P>Thanks!</P><P></P><P>Francesco</P></BODY></HTML> Fri, 30 Mar 2012 07:30:14 GMT https://community.qlik.com/t5/QlikView/How-to-match-two-fields-with-almost-the-same-content/m-p/376093#M140179 2012-03-30T07:30:14Z How to match two fields with almost the same content https://community.qlik.com/t5/QlikView/How-to-match-two-fields-with-almost-the-same-content/m-p/376094#M140180 <HTML><HEAD></HEAD><BODY><P>Hi Francesco,</P><P></P><P>You can use the left() and right() Qlik functions, but this will work only if you know what records have a prefix and which records have a sufix.&nbsp; </P></BODY></HTML> Fri, 30 Mar 2012 07:33:51 GMT https://community.qlik.com/t5/QlikView/How-to-match-two-fields-with-almost-the-same-content/m-p/376094#M140180 jvitantonio 2012-03-30T07:33:51Z How to match two fields with almost the same content https://community.qlik.com/t5/QlikView/How-to-match-two-fields-with-almost-the-same-content/m-p/376095#M140181 <HTML><HEAD></HEAD><BODY><P>Ciao Francesco,</P><P></P><P>you can also try the funcione LIKE :&nbsp;&nbsp;&nbsp; like '*mdfgxx2011*'</P></BODY></HTML> Fri, 30 Mar 2012 07:37:07 GMT https://community.qlik.com/t5/QlikView/How-to-match-two-fields-with-almost-the-same-content/m-p/376095#M140181 Anonymous 2012-03-30T07:37:07Z How to match two fields with almost the same content https://community.qlik.com/t5/QlikView/How-to-match-two-fields-with-almost-the-same-content/m-p/376096#M140182 <HTML><HEAD></HEAD><BODY><P>Like will not work in this case as he needs to join the table. Like is used in a where clause</P></BODY></HTML> Fri, 30 Mar 2012 08:08:16 GMT https://community.qlik.com/t5/QlikView/How-to-match-two-fields-with-almost-the-same-content/m-p/376096#M140182 jvitantonio 2012-03-30T08:08:16Z How to match two fields with almost the same content https://community.qlik.com/t5/QlikView/How-to-match-two-fields-with-almost-the-same-content/m-p/376097#M140183 <HTML><HEAD></HEAD><BODY><P>That's correct....I should have a column with all the values contained both in field 1 and 2 .....like dosn't allow me to match teh entire column values...</P></BODY></HTML> Fri, 30 Mar 2012 08:12:10 GMT https://community.qlik.com/t5/QlikView/How-to-match-two-fields-with-almost-the-same-content/m-p/376097#M140183 2012-03-30T08:12:10Z