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
Solved! Go to Solution.
Are you asking to find where [settle Date] != [settle Date2] for a filter?
Cheers,
Mark
Sorry, i represented the data wrongly,
my input is
Order No | created Date |
19433 | 06/07/2018 |
19435 | 06/07/2018 |
19436 | 06/07/2018 |
19439 | 06/07/2018 |
19440 | 06/07/2018 |
19441 | 06/07/2018 |
19444 | 06/07/2018 |
19445 | 06/07/2018 |
19451 | 06/07/2018 |
19446 | 06/08/2018 |
19448 | 06/08/2018 |
19449 | 06/08/2018 |
19434 | 06/09/2018 |
19437 | 06/09/2018 |
19438 | 06/09/2018 |
19442 | 06/11/2018 |
19443 | 06/11/2018 |
19447 | 06/14/2018 |
19450 | 06/21/2018 |
Output i want was like this
Order No | created Date | Status |
19433 | 06/07/2018 | No |
19434 | 06/09/2018 | Yes |
19435 | 06/07/2018 | No |
19436 | 06/07/2018 | No |
19437 | 06/09/2018 | Yes |
19438 | 06/09/2018 | Yes |
19439 | 06/07/2018 | No |
19440 | 06/07/2018 | No |
19441 | 06/07/2018 | No |
19442 | 06/11/2018 | Yes |
19443 | 06/11/2018 | Yes |
19444 | 06/07/2018 | No |
19445 | 06/07/2018 | No |
19446 | 06/08/2018 | No |
19447 | 06/14/2018 | Yes |
19448 | 06/08/2018 | No |
19449 | 06/08/2018 | No |
19450 | 06/09/2018 | No |
19451 | 06/09/2018 | No |
I have a data set with order no and order date
when the order created with order number, order date should be continuous
in above output example if we see 19433,19435,19436 having the same date i.e 06/07/2018 and actually the order 19434 also should be having the date as 06/07/2018 but the order did not settle till 06/09/2018 its got delayed which is odd needs to identify this kind of pattern.
Thanks
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!