Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Sorting and Ranking a column with dates in another column

Manojkumar
8 - Asteroid

Hi,

 

I have the data in following format.

 

CarPartRepair date
a103-Oct-2013
a223-Apr-2014
a303-Apr-2015
b426-Apr-2015
b212-Jan-2015
b506-May-2014

 

I want to find the order of part "2" in each car (a,b) after sorting the order by repair date for each car.

Can some please help on how to do this in alteryx.

3 REPLIES 3
LordNeilLord
15 - Aurora

Hey @Manojkumar

 

I'd go for multirow formula here, once the data has been sorted you can use the multirow to add a recordID but grouped by car like so:

 

Order.PNG

Manojkumar
8 - Asteroid

Hi @lordneillord

 

Thanks for replying. But I cant find the custom option for changing the Datetime tool. can you please show me how you did that

LordNeilLord
15 - Aurora

Hey @Manojkumar

 

No problem...I've attached the workflow

 

 

Labels
Top Solution Authors