Sort column headers based on months instead of alphabetical

[murthybhs]

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!

[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/619...

Good Luck!

[atcodedog05 · Accepted solution]

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 😀👍

[murthybhs]

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

[atcodedog05]

Happy to help 🙂 @murthybhs 

Cheers and Happy Analyzing 😀

[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

[murthybhs]

Thank you @grazitti_sapna  @Emil_Kos  @atcodedog05  for the help and making this community a valuable source in making budding Alteryx learners like me take the next step.

[grazitti_sapna]

Hi @murthybhs, we are always happy to help. 🙂

Have a great day ahead!

Thanks.  

[atcodedog05]

@murthybhs 

I totally agree with you Alteryx Community is an amazing place 😎

Happy to help 🙂

Feel free to post more questions if you need any assistance, help, info etc

Cheers and Happy Analyzing 😀

[Emil_Kos]

Hi @murthybhs,

I'm blushing now 🙂