Sort column headers based on months instead of alphabetical

Hello everyone,

I have a data set that looks like this:

Here the data is sorted alphabetically instead of the actual months. Can someone help me sorting this data set based on the actual months instead of like the above? I am looking for something like below:

Any help is highly appreciated.

Thank you!

Parse

Preparation

Accepted answers

atcodedog05

Hi @murthybhs

Here is a workflow for the task.

Input: Sep is before Apr

output: Properly sorted

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

sort.yxmd

All comments

Emil_Kos

Hi @murthybhs,

I hope @grazitti_sapna will not have anything against but I remembered he proposed a solution for your problem a while ago:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-Sort-Columns-Month-wise/m-p/619836/highlight/true#M139924

Good Luck!

atcodedog05

Hi @murthybhs

Here is a workflow for the task.

Input: Sep is before Apr

output: Properly sorted

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

sort.yxmd

murthybhs

Yes. Thank you for the response. I did not know the right search terms to use while looking for the solution.

grazitti_sapna

@Emil_Kos Thanks for referring to my post for the solution, I am honored and really appreciate that. Therefore I have made some modification in the solution as required by @murthybhs .

I hope it helps.

Thanks

sort_columns-GS.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703