topic Duplicates in data in QlikView https://community.qlik.com/t5/QlikView/Duplicates-in-data/m-p/261328#M1194033 <HTML><HEAD></HEAD><BODY><P>How can you tell that two lines are different then? I mean, aren't there more fields to concatenate? </P></BODY></HTML> Thu, 02 Jun 2011 22:45:09 GMT erichshiino 2011-06-02T22:45:09Z Duplicates in data https://community.qlik.com/t5/QlikView/Duplicates-in-data/m-p/261327#M1194032 <HTML><HEAD></HEAD><BODY><P>Hello Everyone special,</P><P></P><P>I have two field names Order Number and Product Number. Both these values are coming from Model N.</P><P>Same order number can have multiple Product number. I have to concatenate Order Number and Product Number to create a</P><P>new unique field OrderProductNumber. </P><P>But the problem is in my model the Order number and Product number they repeat several times and there concatenation</P><P>yields many duplicate records in OrderProductNumber.</P><P>And also please suggest how do I concatenate saw that I don't run into duplicates.</P><P></P><P>Could anyone suggest where possibly the mistake is happening.?</P><P></P><P>Thanks and regards,</P><P>Bikash Debnath</P></BODY></HTML> Thu, 02 Jun 2011 18:15:01 GMT https://community.qlik.com/t5/QlikView/Duplicates-in-data/m-p/261327#M1194032 2011-06-02T18:15:01Z Duplicates in data https://community.qlik.com/t5/QlikView/Duplicates-in-data/m-p/261328#M1194033 <HTML><HEAD></HEAD><BODY><P>How can you tell that two lines are different then? I mean, aren't there more fields to concatenate? </P></BODY></HTML> Thu, 02 Jun 2011 22:45:09 GMT https://community.qlik.com/t5/QlikView/Duplicates-in-data/m-p/261328#M1194033 erichshiino 2011-06-02T22:45:09Z