Need Help with sequence

shankar12

I have a data set with order o and order date below are the input and output which i am looking.

Order No	settle Date		Order No	settle Date	Status
19433	06/07/2018		19433	06/07/2018	No
19435	06/07/2018		19434	06/09/2018	Yes
19436	06/07/2018		19435	06/07/2018	No
19439	06/07/2018		19436	06/07/2018	No
19440	06/07/2018		19437	06/09/2018	Yes
19441	06/07/2018		19438	06/09/2018	Yes
19444	06/07/2018		19439	06/07/2018	No
19445	06/07/2018		19440	06/07/2018	No
19451	06/07/2018		19441	06/07/2018	No
19446	06/08/2018		19442	06/11/2018	Yes
19448	06/08/2018		19443	06/11/2018	Yes
19449	06/08/2018		19444	06/07/2018	No
19434	06/09/2018		19445	06/07/2018	No
19437	06/09/2018		19446	06/08/2018	No
19438	06/09/2018		19447	06/14/2018	Yes
19442	06/11/2018		19448	06/08/2018	No
19443	06/11/2018		19449	06/08/2018	No
19447	06/14/2018		19450	06/09/2018	No
19450	06/21/2018		19451	06/09/2018	No

when the order created with order number, order date  should be continuous like in above example if we see 19433,19435,19436 having the same date i.e 06/07/2018 and actually the 19434 date is is 06/09/2018 which is odd needs to identify those.

Thanks

danrh

Something like this?

If your created Date is already in a date format, you won't need the DateTime tool. Also, the Select and the last Sort tools are just reformatting the data to how you had it in your example output.  This looks for discrepancies in the order number when the data set is ordered by Create date.

Take a look, hope it helps!

solution.yxmd