Forum Discussion
Solved
Identify duplicate rows
Hello togehter, Table1 Cost Center GL Account DocNo Amount 2525001 5455506 DE452K 450.11 2525001 5455506 DE477B 450.11 2525040 5456000 DE333C 83.45 I want to ident...
But, you can convert a text inside in measure to a number using the VALUE function
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.
For this cinaria you need like this
https://1drv.ms/u/s!AiUZ0Ws7G26RhjCoMtuTrBnmXanZ?e=z5Kwd7
But what If the Cost Center or the GL Account is not a number. It is a text field.
But, you can convert a text inside in measure to a number using the VALUE function