Sorting and Ranking a column with dates in another column

[Manojkumar]

Hi,

I have the data in following format.

Car	Part	Repair date
a	1	03-Oct-2013
a	2	23-Apr-2014
a	3	03-Apr-2015
b	4	26-Apr-2015
b	2	12-Jan-2015
b	5	06-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 solution]

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 solution]

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 solution]

Hey @Manojkumar

No problem...I've attached the workflow