Forum Discussion
Date sequence validation for duplicates
Hello everyone I appreciate if you can help me with this consultation. I have the following table: I need to perform the following validations: - check if there is duplicate data in the "...
show me an example so I can understand you
Hello, thank you. Attached example table. In red the records that are with FILE status but that do not have duplicate order, but that should appear as OK.
An additional query, this columa result, can be added to the table and not as a measure? in that case, the other fields that are blank, could be with OK? This would be easier for me to be able to count the errors and show them in a label in the visualizations.
Thanks a lot!
| Invoice | State | Order | Issue date | Cancellation date | Result |
| 235-2023-000446 | Regularized | 000172844030 | 30/01/2023 21:25:43 | ||
| 235-2023-000095 | LEGAJADA | 00172843960 | 6/01/2023 22:50:15 | 6/01/2023 23:16:37 | OK |
| 235-2023-000027 | LEGAJADA | 014494368470 | 3/01/2023 18:29:02 | 3/01/2023 21:53:35 | OK |
| 235-2023-000026 | LEGAJADA | 014494368514 | 3/01/2023 18:29:02 | 4/01/2023 18:24:54 | Error |
| 235-2023-000046 | 014494368514 | 4/01/2023 18:23:30 | |||
| 235-2023-000185 | LEGAJADA | 014494369015 | 13/01/2023 00:19:03 | 13/01/2023 00:22:56 | OK |
| 235-2023-000201 | 014494369015 | 13/01/2023 19:39:18 | |||
| 235-2023-000186 | LEGAJADA | 014494369026 | 13/01/2023 00:19:03 | 13/01/2023 00:22:57 | OK |
| 235-2023-000202 | 014494369026 | 13/01/2023 19:39:18 | |||
| 235-2023-000200 | 014494369041 | 13/01/2023 19:39:18 | |||
| 235-2023-000249 | LEGAJADA | 014494369170 | 17/01/2023 18:46:53 | 19/01/2023 11:22:15 | Error |
| 235-2023-000271 | 014494369170 | 18/01/2023 18:30:04 | |||
| 235-2023-000248 | 014494369181 | 17/01/2023 18:46:53 | |||
| 235-2023-000247 | LEGAJADA | 014494369214 | 17/01/2023 18:46:53 | 18/01/2023 11:22:14 | OK |
| 235-2023-000268 | 014494369214 | 18/01/2023 18:30:04 | |||
| 235-2023-000437 | 014494377301 | 30/01/2023 19:20:42 | |||
| 235-2023-000436 | LEGAJADA | 014494377312 | 30/01/2023 19:20:42 | 30/01/2023 20:54:04 | OK |
| 235-2023-000438 | LEGAJADA | 014494377323 | 30/01/2023 19:20:42 | 31/01/2023 12:18:38 | OK |
| 235-2023-000440 | LEGAJADA | 014494377334 | 30/01/2023 19:20:42 | 31/01/2023 12:18:39 | OK |
| 235-2023-000442 | 014494377382 | 30/01/2023 19:20:42 | |||
| 235-2023-000439 | 014494377404 | 30/01/2023 19:20:42 | |||
| 235-2023-000441 | 014494377415 | 30/01/2023 19:20:42 | |||
| 235-2023-000118 | LEGAJADA | 099612220552 | 9/01/2023 00:00:00 | 9/01/2023 22:50:58 | OK |
| 235-2023-000119 | 099612220552 | 9/01/2023 22:55:49 | |||
| 235-2023-000138 | LEGAJADA | 099612220563 | 10/01/2023 22:21:58 | 11/01/2023 13:23:23 | OK |
| 235-2023-000157 | 099612220563 | 11/01/2023 22:47:01 |