Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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
Honored Contributor

Duplicates in data

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