Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Automatic Sort after Sum

avidaci
5 - Atom

Hello,

 

I used to work alot in Alteryx a few years ago, and now I'm back.

 

I began yesterday w version : 2022.3.1.395 (trial so far) and I had one issue:

 

After a Sum (or cross tab) the data used to be sorted on the Group By variables, but now when i apply this tool the data is in random order. Is this some new 'feature', and is it possible to revert it back to nice and sorted?

 

Thanks for help!

3 REPLIES 3
DataNath
17 - Castor
17 - Castor

Hi @avidaci, with you using a newer version, AMP will be the default engine which is the likely cause of this. If you hit any whitespace on your canvas and then go to the 'Runtime' tab and untick 'Use AMP Engine', does that help?

 

DataNath_0-1677160306568.png

 

Without AMP:

 

DataNath_1-1677160320005.png

 

With AMP:

 

DataNath_2-1677160335193.png

avidaci
5 - Atom

It worked! :) Thanks alot

phottovy
13 - Pulsar
13 - Pulsar

I was wondering why the functionality changed. Thanks @DataNath 

Labels