In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

sort by date

Sshasnk
8 - Asteroid

I have to sort by date 

 

Date
12/2023 YE
1/2022 YE
1/2023 YE
3/2022 YE
2/2023 YE

 

The above data should be sorted to the latest date first

 

For example: 12/2023 is the latest and then 2/2023 and so on... 

2 REPLIES 2
ShankerV
17 - Castor

Hi @Sshasnk 

 

One way of doing this.

 

ShankerV_0-1680626569809.png

 

Note: You can use the select tool to remove the columns Regexout1 and 2 also. Used for sorting purpose, post sort tool, it can be deselected using Select tool if needed.

 

Many thanks

Shanker V

ShankerV
17 - Castor

Hi @Sshasnk 

 

One more way to avoid creating 2 columns for calculation.

 

ShankerV_0-1680626901806.png

 

Many thanks

Shanker V

Labels
Top Solution Authors