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 "...
Thanks for the reply. On the result, this OK, however I have left another condition: - there may be records with cancellation date but that does not have duplicate the order. in this case, it should also be OK. Please your help. Thank you.
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 Hello, please confirm if you could review it? Thank you!
check the solution!
https://1drv.ms/u/s!AiUZ0Ws7G26Rhm76ey3HyQv2GwHz?e=I6K8C5