Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

How to have the dates in chronological order within a row

Highlighted
8 - Asteroid

Hello,

 

I need to have the dates in chronological order within a row. The row can have from 1 to 7 different dates. Current state and desired state examples below.

 

Thank you,

Kim

 

Current State

Job IdBilling DateRight_Billing DateLeft_Right_Billing DateLeft_Right_Billing DateLeft_Right_Billing DateLeft_Right_Billing DateLeft_Right_Billing DateLeft_Right_Billing Date
MAR00 MAR000041/1/2020       
MAR00 MAR000091/1/2020       
MAR00 MAR000141/1/2020       
ACVRURPA AVRRPAB16/18/201911/20/2018      
JAQX004 IAQX004N1/1/20171/1/2018      
JARX001 IARX0011/1/20171/1/2018      
ACVRUVNA AVRVNAB11/20/20175/18/20185/1/2018     
FIR02 FIR020011/1/20171/1/20201/1/2018     
FIR02 FIR020021/1/20171/14/20201/1/2018     
FSX15 SYSUT1241/1/20171/1/20201/1/2018     
CKS26 CKS260011/1/20176/1/20196/1/20186/1/20171/1/2018   
IBFX046G IBF46E011/1/20174/24/20204/3/20181/1/20201/1/2018   
JSRX062 ISRX0621/1/20178/1/20193/2/20201/1/20201/1/2018   
AGB06D AGB060111/1/20176/1/20196/1/20186/1/20171/1/20181/1/2020  
ASP20 ASP200101/1/20176/1/20196/1/20186/1/20171/1/20181/1/2020  
ASPMR10 ASPMR0011/1/20186/3/20196/1/20186/1/20171/2/20171/2/2020  
ACVRUVN7 AVRVN7B11/1/20176/7/20176/1/20196/1/20181/1/20181/1/20201/20/20171/22/2018
ACVRUVN7 AVRVN7B11/1/20176/20/20176/1/20196/1/20181/1/20181/1/20201/20/20171/22/2018
ACVRUVN7 AVRVN7B11/1/20176/20/20186/1/20196/1/20181/1/20181/1/20201/20/20171/22/2018

 

Desired state

Job IdBilling DateRight_Billing DateLeft_Right_Billing DateLeft_Right_Billing DateLeft_Right_Billing DateLeft_Right_Billing DateLeft_Right_Billing DateLeft_Right_Billing Date
MAR00 MAR000041/1/2020       
MAR00 MAR000091/1/2020       
MAR00 MAR000141/1/2020       
ACVRURPA AVRRPAB111/20/20186/18/2019      
JAQX004 IAQX004N1/1/20171/1/2018      
JARX001 IARX0011/1/20171/1/2018      
ACVRUVNA AVRVNAB11/20/20175/1/20185/18/2018     
FIR02 FIR020011/1/20171/1/20181/1/2020     
FIR02 FIR020021/1/20171/1/20181/14/2020     
FSX15 SYSUT1241/1/20171/1/20181/1/2020     
CKS26 CKS260011/1/20176/1/20171/1/20186/1/20186/1/2019   
IBFX046G IBF46E011/1/20171/1/20184/3/20181/1/20204/24/2020   
JSRX062 ISRX0621/1/20171/1/20188/1/20191/1/20203/2/2020   
AGB06D AGB060111/1/20176/1/20171/1/20186/1/20186/1/20191/1/2020  
ASP20 ASP200101/1/20176/1/20171/1/20186/1/20186/1/20191/1/2020  
ASPMR10 ASPMR0011/2/20176/1/20171/1/20186/1/20186/3/20191/2/2020  
ACVRUVN7 AVRVN7B11/1/20171/20/20176/7/20171/1/20181/22/20186/1/20186/1/20191/1/2020
ACVRUVN7 AVRVN7B11/1/20171/20/20176/20/20171/1/20181/22/20186/1/20186/1/20191/1/2020
ACVRUVN7 AVRVN7B11/1/20171/20/20171/1/20181/22/20186/1/20186/20/20186/1/20191/1/2020

 

Highlighted
Alteryx
Alteryx

This gets you pretty close, but I wasn't sure why the job ID ACVRUVN7 AVRVN7B1 was listed on three separate rows. My workflow combined them all into one row. That could be fixed, but I didn't know if this is a nuance of your data or if every Job ID was unique. Workflow is attached. 

 

Order dates.png

Highlighted
Alteryx
Alteryx

I think that this is probably closer to what you want. Workflow for this version is also attached. 

 

order v2.png

Highlighted
16 - Nebula

@kas I posted a solution to your other post

 

DavidP_0-1596148064771.png

 

Highlighted
8 - Asteroid

@BrandonB and @DavidP 

So sorry! Apparently I was having issues within the community yesterday with my request not posting and it later duplicated...this has been solved. @BrandonB your solution looks like the one that ended up being used.

 

Thank you both for your time and I again apologize for the extra posts that occured!

 

Kim

Labels