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.
fireworks
SOLVED

Sorting Data error

SorinDiaconescu
6 - Meteoroid

Hello.

 

I have a date column I want to sort. Using the sort option I mark it as sorting descending and it does sort the years, but not the month or day. any ideas why?

 Capture.JPG

 

5 REPLIES 5
LordNeilLord
15 - Aurora

Hey @SorinDiaconescu

 

It sorted fine for me when I did a quick test!

 

Can you share some data?

SorinDiaconescu
6 - Meteoroid

Here is a small sample. I cant share more.

 

Thanks,
Sorin

LordNeilLord
15 - Aurora

Hey @SorinDiaconescu

 

It worked fine for me, i did notice that the sort is messed up if you have the "use dictionary order" button ticked

 

Sort.PNG

SorinDiaconescu
6 - Meteoroid

So funny. I unticked the box and it sorted perfectly. thanks

ronvv
5 - Atom

Thanks for this tip....I had a similar issue and unchecking the box appears to have resolved it

Labels
Top Solution Authors