1 Reply Latest reply: Jun 2, 2011 6:45 PM by Erich Shiino RSS

    Duplicates in data

      Hello Everyone special,

       

      I have two field names Order Number and Product Number. Both these values are coming from Model N.

      Same order number can have multiple Product number. I have to concatenate Order Number and Product Number to create a

      new unique field OrderProductNumber.

      But the problem is in my model the Order number and Product number they repeat several times and there concatenation

      yields many duplicate records in OrderProductNumber.

      And also please suggest how do I concatenate saw that I don't run into duplicates.

       

      Could anyone suggest where possibly the mistake is happening.?

       

      Thanks and regards,

      Bikash Debnath