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.
Solved! Go to 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:
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