after a GroupBy , Sort by column question

Question

i am working with Movie data, and did a "Group by" category, within each category is a movie title.... right now the title are NOT in alphabetical order.... IF i add a Sort tool after the Group by.... it sort the original file alphabetically, completely ignoring the Groupby...

After a Group By, what is proper way to Sort a details column  of the Group By

(i feel there is an "order of operation" within Alteryx, that I am not getting... this type of behavior isn't the first time.)  thanks for any insight

Alteryx, GroupBy, Sort.png

ncrlelia · Answer

Hi @MTS,

Happy that we are able to help.

It will be great if you can accept our solutions. 
Thank you.

Cheers,

Lelia

MTS · Answer

both solutions worked.  thank yyou

ncrlelia · Answer

Hi @MTS,

If you are using the Summarize tool for your 'GroupBy' action, you can also achieve the sorting result (shared by Qiu) by adding another layer of GroupBy for the Title in the Summarize tool.

Input data

Output of Summarize Tool

Hope this helps.

Cheers,

Lelia