Forum Discussion
Identify duplicate rows
But, you can convert a text inside in measure to a number using the VALUE function
Thx for your reply. The part DocNo is unequal DocNo is important. This should not be the same.
Hi Stelles3000
I identify with duplicate but the doc number is different in all the codes if you see I'm only comparing gl account, cost center and amount. The result is giving the same has you present on the post two lines and different doc numbers.
Isn't that the result you want?
Yes, but the DocNo must be different, so it should not equal. There are examples with identical values, I dont want these.
Sorry for the additional questions, so when you have a docnum equal you don't want to count the repetead ones?
Can you send an example of data where you have that type of information (duplicated doc numbers) and expected result? On the first example you only had 3 lines so it's diffficult to duplicate your data and get accurate results.
Thank you in advance.
There could be more than 5000 rows in different order.
Cost Center GL Account DocNo Amount Flag 2525001 5455506 DE452K 450.11 Dublicated 2525040 5456000 DE333C 83.45 2525001 5455506 DE477B 450.11 Dublicated 2525002 5455506 DFG56B 36.9 2525003 5455506 DFKB90 50.01 2525004 5455506 DFKB90 35.04 2525002 5455506 DFG56B 36.9 This Column "Flag" should be the result. I am looking for a pattern with specific rules.