Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Sorting data by a particular value then group by another

DS1810
6 - Meteoroid

Dear all,

 

I have this data list that now is sort by "transaction number" column A. Each transaction number is a set of data that always need to be grouped together. In total there are 4 sets of data as below.

 

pic 2.png

 

Now i wish to sort the 4 data sets, in the order that the amount of account # 112101 is ascending.

 

In other words, if you look at column C, there is this account numbered 112101, and it's value is in the same row under column F. I want this account's amount to be sort in ascending order, however, to keep the data sets still in it's own group.

 

The desired output would be:

 

pic.png

 

In this case, the account 112101 is in ascending order (-1234056.95 < -199999 < -40000 <-12748.07), but the data are still grouped as by the transaction number.

 

Appreciate if anyone can help!!!! 😁

2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

Hi @DS1810 

 

Here is how you can do it.

 

Workflow:

atcodedog05_0-1626767847840.png

 

1. Using filter to get only 112101 values.

2. Using find and replace and adding 112101 amount values to all rows of its respective transition. This way transactions can be sorted by 112101 amt.

3. Sorting on 112101 amount ascending, transaction number ascending and acct ascending.

 

Hope this helps : )

 

DS1810
6 - Meteoroid

Dear  

 

This is amazing!!! it works!!! Thank you so much 😃

Labels