Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Need Help with sequence

shankar12
8 - Asteroid

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

 

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

 

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

 

 

 

3 REPLIES 3
MarqueeCrew
20 - Arcturus
20 - Arcturus

@shankar12,

 

Are you asking to find where [settle Date] != [settle Date2] for a filter? 

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
shankar12
8 - Asteroid

Sorry, i represented the data wrongly,

 

my input is 

Order Nocreated 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 Nocreated DateStatus
19433 06/07/2018No
19434 06/09/2018Yes
19435 06/07/2018No
19436 06/07/2018No
19437 06/09/2018Yes
19438 06/09/2018Yes
19439 06/07/2018No
19440 06/07/2018No
19441 06/07/2018No
19442 06/11/2018Yes
19443 06/11/2018Yes
19444 06/07/2018No
19445 06/07/2018No
19446 06/08/2018No
19447 06/14/2018Yes
19448 06/08/2018No
19449 06/08/2018No
19450 06/09/2018No
19451 06/09/2018No

 

 

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

danrh
13 - Pulsar

Something like this?

image.png

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!

Labels