Discussion board where members can get started with QlikView.
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,
How can you tell that two lines are different then? I mean, aren't there more fields to concatenate?