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