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

how to sort two columns independently from each other?

xariet
8 - Asteroid

Hi All!

I have two columns which I need to sort independently from each other, sort (group) by part # first and then assign Category in the alphabetical order and Null values at the bottom, not at the top as Alteryx does with the sorting tool

Thanks for your help

 

OUTPUT
part#        Category

35648             A
35648            B
35648             C  

35648             D
35648           Null
35648           Null
13427865     A
13427865     D
13427865     E
43900         B

 

5 REPLIES 5
Qiu
21 - Polaris
21 - Polaris

@xariet 
This is exactly the Sorting tool can do, if I am not mistaken.

0822-xariet.PNG

Biswarun
8 - Asteroid

To add to @Qiu's solution, please be careful about the order of the fields in the sort tool. That's important!

xariet
8 - Asteroid

Thank you @Qiu . Is there a way if I have Null values in the Category to put them at the bottom? when I am sorting Ascending all Null values come at the top. I have updated my question.

xariet
8 - Asteroid

Thank you @Biswarun 

Is there a way if I have Null values in the Category to put them at the bottom? when I am sorting Ascending all Null values come at the top. I have updated my question.

Qiu
21 - Polaris
21 - Polaris

@xariet 
We can add a SN for null to be 1 and other to be zero as below.

0829-xariet.PNG0829-xariet-1.PNG

Labels
Top Solution Authors