Sort Week Rows Chronologically

araquecastro

Hi people,

I have an output file with over 50000 results with several columns. One of the column headers is WEEK with the following result (this is an extract of the final results). 

I want all data to be organize chronologically like the right image. Thanks for the help you can provide.

PD: This is my first post and not acquainted with the way to post tables so far.

WEEKS.png

CoG

This formula should give you a sorting field:

DateTimeFormat(DateTimeParse(GetWord([WEEK], 0),"%b"),"%m") + Right([WEEK],1)

Sample Workflow Chronological Week.yxmd