how to sort two columns independently from each other?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@xariet
This is exactly the Sorting tool can do, if I am not mistaken.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
To add to @Qiu's solution, please be careful about the order of the fields in the sort tool. That's important!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@xariet
We can add a SN for null to be 1 and other to be zero as below.