Dynamic rename ordered by Month and year

My workflow takes a date field, strips it down to Mon - yyyy then does a cross tab to make the months columns. Here lays the issue; the cross tab orders the columns in alphabetical order but it needs to be ordered by date, e.g. Jan-2022 Apr-2022 NOT Apr-2022 Jan-2022.

Dynamic rename date columns.yxmd

Transformation

Preparation

Accepted answers

binu_acs

@Brinker another way of dong this

Dynamic rename date columns.yxmd

All comments

Luke_C

Hi @Brinker

Maybe something like this? I updated your formula tool to output the month number instead, then handled updating to the month name in the dynamic rename.

Dynamic rename date columns.yxmd

ChrisTX

Check out this post, which uses RecordId

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Breakdown-one-column-into-lagged-columns/td-p/463010

danilang
This workflow gives you close to what you're looking for.

The record Id in the top branch will be used to get around the fact the final Cross tab tool will arrange output rows alphabetically

And this one:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Count-the-non-null-values-across-multiple-columns/td-p/436565

solution attached to post above includes a dynamic re-name of columns, based on the original column order

and this one:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-order-columns-by-any-given-line-values/m-p/406629

This article might be useful:

Can the real [Field Name] please stand up...

https://community.alteryx.com/t5/Engine-Works/Can-the-real-Field-Name-please-stand-up/ba-p/611088

And finally, look at the attached Word document which contains an embedded workflow. I started with a post from the Austin user group and created the workflow inside the Word document.

Chris

Use Dynamic Rename to fix Crosstab headers.docx

JagdeeshN

@Brinker

The below formula in the dynamic input tool should do the trick for you:-

REPLACE([_CurrentField_],[_CurrentField_],Datetimeformat(replace([_CurrentField_],'_','-'), '%B-%Y'))

This basically replaces the _ first and then parses the date string.

Please find attached a sample. Hope this helps.

Best,

Jagdeesh

Dynamic rename date columns.yxmd

binu_acs

@Brinker another way of dong this

Dynamic rename date columns.yxmd

Brinker

@ChrisTX There were so many of these all just slightly different from mine and I couldn't manage to tweak it. Thank you very much, hope this posts and your links helps others.

Brinker

@binu_acsThank you so much! Works like a charm

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703