Sorting and Ranking a column with dates in another column

Question

Hi,

I have the data in following format.

CarPartRepair datea103-Oct-2013a223-Apr-2014a303-Apr-2015b426-Apr-2015b212-Jan-2015b506-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.

LordNeilLord · Accepted Answer

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:

Manojkumar · Accepted Answer

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 · Accepted Answer

Hey @Manojkumar

No problem...I've attached the workflow