Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

1 Reply
erichshiino
Partner - Master
Partner - Master

How can you tell that two lines are different then? I mean, aren't there more fields to concatenate?