how to sort date from oldest to newest for particular number and create blank rows

[prthmesh111]

below is the input file which contains number, date and type

Number	Type	Date
1234	received	9/13/2023
1234	received	9/13/2023
1234	delivered	9/13/2023
2356	received	10/22/2023
2356	received	5/22/2023
2356	received	10/22/2023
2356	received	5/22/2023
2356	delivered	5/22/2023
2356	delivered	10/22/2023

Output should be like below

Number	Type	Date
1234	received	9/13/2023
1234	received	9/13/2023
1234	delivered	9/13/2023
2356	received	5/22/2023
2356	received	5/22/2023
2356	delivered	5/22/2023
2356	received	10/22/2023
2356	received	10/22/2023
2356	delivered	10/22/2023

the sorting must be based on date and matching number and it should generate empty rows after every delivered type

[wwatson]

You should start by making sure the date column is defined as a date rather than a string. From first glance the Date column looks like  a string. You can convert it to a date using the DateTime Parse tool.

Once parsed to a date type the normal sort tool should sort it correctly.

[Thableaus]

Hi @prthmesh111 

Here's one alternative. WF attached.

Cheers,

[wwatson · Accepted solution]

Full solution enclosed:

[prthmesh111]

thanks for the solution. it was same as required . could you please help me in one more question below is the link

https://community.alteryx.com/t5/Alteryx-Designer/how-to-compare-each-row-of-received-number-with-de...

[prthmesh111]

thanks for the reply . you to provided a right soution. but the perfect one which work on my dataset as expected is of wwatson