We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start 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