Hi I have a column with monthly periods repeating from Jan-21 to Dec-21 (Month-Year) and I would like to sort the rows so that the periods repeat from Jan-21 to Dec-21. For Example, below is my source and target table: Source: PeriodValue1Value2221-JanDummy1Dummy621-JanDummy3Dummy121-JanDummy3Dummy421-FebDummy2Dummy721-FebDummy1Dummy521-FebDummy1Dummy121-MarDummy3Dummy321-MarDummy5Dummy1021-MarDummy5Dummy421-AprDummy4Dummy321-AprDummy6Dummy121-AprDummy2Dummy321-MayDummy3Dummy321-MayDummy1Dummy921-MayDummy3Dummy421-JunDummy4Dummy121-JunDummy5Dummy821-JunDummy4Dummy321-JulDummy3Dummy521-JulDummy3Dummy1021-JulDummy1Dummy721-AugDummy1Dummy1021-AugDummy4Dummy421-AugDummy5Dummy321-SepDummy5Dummy121-SepDummy3Dummy321-SepDummy10Dummy321-OctDummy6Dummy921-OctDummy4Dummy121-OctDummy1Dummy321-NovDummy1Dummy821-NovDummy3Dummy321-NovDummy6Dummy521-DecDummy5Dummy1021-DecDummy1Dummy321-DecDummy1Dummy6 Target: PeriodValue1Value2221-JanDummy1Dummy621-FebDummy3Dummy121-MarDummy3Dummy421-AprDummy2Dummy721-MayDummy1Dummy521-JunDummy1Dummy121-JulDummy3Dummy321-AugDummy5Dummy1021-SepDummy5Dummy421-OctDummy4Dummy321-NovDummy6Dummy121-DecDummy2Dummy321-JanDummy3Dummy321-FebDummy1Dummy921-MarDummy3Dummy421-AprDummy4Dummy121-MayDummy5Dummy821-JunDummy4Dummy321-JulDummy3Dummy521-AugDummy3Dummy1021-SepDummy1Dummy721-OctDummy1Dummy1021-NovDummy4Dummy421-DecDummy5Dummy321-JanDummy5Dummy121-FebDummy3Dummy321-MarDummy10Dummy321-AprDummy6Dummy921-MayDummy4Dummy121-JunDummy1Dummy321-JulDummy1Dummy821-AugDummy3Dummy321-SepDummy6Dummy521-OctDummy5Dummy1021-NovDummy1Dummy321-DecDummy1Dummy6 Could anyone pls help with this? Thank you!!

Sort Column

Hi I have a column with monthly periods repeating from Jan-21 to Dec-21 (Month-Year) and I would like to sort the rows so that the periods repeat from Jan-21 to Dec-21. For Example, below is my source and target table:

Source:

Period	Value1	Value22
21-Jan	Dummy1	Dummy6
21-Jan	Dummy3	Dummy1
21-Jan	Dummy3	Dummy4
21-Feb	Dummy2	Dummy7
21-Feb	Dummy1	Dummy5
21-Feb	Dummy1	Dummy1
21-Mar	Dummy3	Dummy3
21-Mar	Dummy5	Dummy10
21-Mar	Dummy5	Dummy4
21-Apr	Dummy4	Dummy3
21-Apr	Dummy6	Dummy1
21-Apr	Dummy2	Dummy3
21-May	Dummy3	Dummy3
21-May	Dummy1	Dummy9
21-May	Dummy3	Dummy4
21-Jun	Dummy4	Dummy1
21-Jun	Dummy5	Dummy8
21-Jun	Dummy4	Dummy3
21-Jul	Dummy3	Dummy5
21-Jul	Dummy3	Dummy10
21-Jul	Dummy1	Dummy7
21-Aug	Dummy1	Dummy10
21-Aug	Dummy4	Dummy4
21-Aug	Dummy5	Dummy3
21-Sep	Dummy5	Dummy1
21-Sep	Dummy3	Dummy3
21-Sep	Dummy10	Dummy3
21-Oct	Dummy6	Dummy9
21-Oct	Dummy4	Dummy1
21-Oct	Dummy1	Dummy3
21-Nov	Dummy1	Dummy8
21-Nov	Dummy3	Dummy3
21-Nov	Dummy6	Dummy5
21-Dec	Dummy5	Dummy10
21-Dec	Dummy1	Dummy3
21-Dec	Dummy1	Dummy6

Target:

Period	Value1	Value22
21-Jan	Dummy1	Dummy6
21-Feb	Dummy3	Dummy1
21-Mar	Dummy3	Dummy4
21-Apr	Dummy2	Dummy7
21-May	Dummy1	Dummy5
21-Jun	Dummy1	Dummy1
21-Jul	Dummy3	Dummy3
21-Aug	Dummy5	Dummy10
21-Sep	Dummy5	Dummy4
21-Oct	Dummy4	Dummy3
21-Nov	Dummy6	Dummy1
21-Dec	Dummy2	Dummy3
21-Jan	Dummy3	Dummy3
21-Feb	Dummy1	Dummy9
21-Mar	Dummy3	Dummy4
21-Apr	Dummy4	Dummy1
21-May	Dummy5	Dummy8
21-Jun	Dummy4	Dummy3
21-Jul	Dummy3	Dummy5
21-Aug	Dummy3	Dummy10
21-Sep	Dummy1	Dummy7
21-Oct	Dummy1	Dummy10
21-Nov	Dummy4	Dummy4
21-Dec	Dummy5	Dummy3
21-Jan	Dummy5	Dummy1
21-Feb	Dummy3	Dummy3
21-Mar	Dummy10	Dummy3
21-Apr	Dummy6	Dummy9
21-May	Dummy4	Dummy1
21-Jun	Dummy1	Dummy3
21-Jul	Dummy1	Dummy8
21-Aug	Dummy3	Dummy3
21-Sep	Dummy6	Dummy5
21-Oct	Dummy5	Dummy10
21-Nov	Dummy1	Dummy3
21-Dec	Dummy1	Dummy6

Could anyone pls help with this?

Thank you!!

Workflow

Transformation

Help

Accepted answers

ed_hayter

I went with a multi-row formula grouped by period to give each occurance an ID. Parsed the dates so i could sort on ID and date then removed the parse date so its not in the final output.

sort_flow.yxmd

All comments

ed_hayter

I went with a multi-row formula grouped by period to give each occurance an ID. Parsed the dates so i could sort on ID and date then removed the parse date so its not in the final output.

sort_flow.yxmd

DataNath

Hey @jaiiracha, here's one way you could go about it whereby you:

1) Use a Multi-Row Formula, grouped by period to create a grouped Index

2) Parse the period into an actual date so it can be sorted properly

3) Sort by the Index (ascending) order, followed by the true date (ascending) order

Can't see any obvious sorting of your other [Value1] and [Value22] columns so haven't touched them but happy to take another look if this is important.

Sort repeating periods.yxmd

FinnCharlton

Hi @jaiiracha , here's how I would approach this. Bear in mind this doesn't take into account any logic from your Dummy fields

Sort Dates.yxmd

jaiiracha

All great solutions! thank you all!!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703