Sorting column in the order I want

Hi:

I need to sort columns by giving it a sort order but I am not able to figure it out. For example: I have month as my column like Jan, Feb and Mar but currently, the output is not giving to me in that order. I would like to assign if it is Jan, then order number of 1 and if it is Feb then an order number of 2 and March the order number of 3 and so forth and then sort the column in that order for output to Excel. This is because I don't know what months will be available (month will be added as time goes on). Appreciate any help provided.

Thank You.

Common Use Cases

Accepted answers

echuong1

I believe you're looking to reorder the actual columns, correct? If so, the attached should work for you. It essentially pivots the data so the field names are actual data pieces. From there, you can assign the order and then sort based on assigned order. After that, you can pivot the data back.

Let me know if this works for you!

New Workflow2.yxmd

All comments

fmvizcaino

Hi @Taki ,

A suggestion is for you to have an additional table with all the numbers for the months but you can also can get the month number by using the function datetimeformat.

Examples attached.

Best,

Fernando Vizcaino

2020-06-25 Sorting column in the order I want.yxmd

echuong1

Let me know if this works for you!

New Workflow2.yxmd

Taki

Thank You.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703