topic How to remove duplicate text in a field? in QlikView https://community.qlik.com/t5/QlikView/How-to-remove-duplicate-text-in-a-field/m-p/197381#M57073 <HTML><HEAD></HEAD><BODY><P>Generally I think that using DISTINCT in combination with SUBFIELD() could solve the problem. But actually I'd deem it impudent to give more detailled advice without knowing more details.</P><P>Regards,<BR />Joachim</P></BODY></HTML> Thu, 24 Sep 2009 02:28:16 GMT biester 2009-09-24T02:28:16Z How to remove duplicate text in a field? https://community.qlik.com/t5/QlikView/How-to-remove-duplicate-text-in-a-field/m-p/197380#M57072 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a text field where every row contains many product codes. One row might look like below (data is separated by ','):</P><P>12y,14c,23k,24t,12y</P><P>My problem is that many rows might contain duplicate (or more) product codes. From above example, product code 12y appear twice.</P><P>How can I automatically remove alla duplicate instances so that only one distinct product code remains on every row? In above example, 12y would have been removed automatically either from the end or the start.</P><P>Thanks in advance,<BR />Thomas</P></BODY></HTML> Thu, 24 Sep 2009 02:07:29 GMT https://community.qlik.com/t5/QlikView/How-to-remove-duplicate-text-in-a-field/m-p/197380#M57072 2009-09-24T02:07:29Z How to remove duplicate text in a field? https://community.qlik.com/t5/QlikView/How-to-remove-duplicate-text-in-a-field/m-p/197381#M57073 <HTML><HEAD></HEAD><BODY><P>Generally I think that using DISTINCT in combination with SUBFIELD() could solve the problem. But actually I'd deem it impudent to give more detailled advice without knowing more details.</P><P>Regards,<BR />Joachim</P></BODY></HTML> Thu, 24 Sep 2009 02:28:16 GMT https://community.qlik.com/t5/QlikView/How-to-remove-duplicate-text-in-a-field/m-p/197381#M57073 biester 2009-09-24T02:28:16Z How to remove duplicate text in a field? https://community.qlik.com/t5/QlikView/How-to-remove-duplicate-text-in-a-field/m-p/197382#M57074 <HTML><HEAD></HEAD><BODY><P>Yes, if do it in the script, it will be cutting in pieces by subfield, and on the next step concatenating by concat(distinct ...)</P></BODY></HTML> Thu, 24 Sep 2009 03:41:24 GMT https://community.qlik.com/t5/QlikView/How-to-remove-duplicate-text-in-a-field/m-p/197382#M57074 Anonymous 2009-09-24T03:41:24Z How to remove duplicate text in a field? https://community.qlik.com/t5/QlikView/How-to-remove-duplicate-text-in-a-field/m-p/197383#M57075 <HTML><HEAD></HEAD><BODY><P>Thanks Joachim, that did the trick! <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P></BODY></HTML> Thu, 24 Sep 2009 04:34:25 GMT https://community.qlik.com/t5/QlikView/How-to-remove-duplicate-text-in-a-field/m-p/197383#M57075 2009-09-24T04:34:25Z