Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
Free Trial

Alteryx Designer Desktop Discussions

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

Ho get dates in Ascending order

shahnawaz_khan
8 - Asteroid

Hi,

 

Please help to get dates in ascending order.

 

From  below         
Country01-Jan-2403-Jan-2402-Jan-2405-Jan-2406-Jan-2404-Jan-2403-Feb-2401-Feb-2402-Feb-24
US111111111
Africa111111111
UK111111111
Canada111111111
France111111111
          
          
To below         
Country01-Jan-2402-Jan-2403-Jan-2404-Jan-2405-Jan-2406-Jan-2401-Feb-2402-Feb-2403-Feb-24
US111111111
Africa111111111
UK111111111
Canada111111111
France111111111
3 REPLIES 3
binuacs
21 - Polaris

@shahnawaz_khan one way of doing this

image.png

Raj
16 - Nebula

@shahnawaz_khan 
another way of doing this

Raj
16 - Nebula

@shahnawaz_khan 
added another way which can be used if any of the records are missing some values for some columns

Hope this helps.

Labels
Top Solution Authors