Alteryx Designer Desktop Discussions

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

Sort tool only sorting the columns mentioned and not the whole extract

dtrix
7 - Meteor

Hi,

 

I used Sort tool. And mention how I want to sort the data using a few columns. However, in the output only those specific columns are sorted while the rest of the data stays the same.

How do I use the Sort tool so based on the criteria the whole data is sorted?

 

Thanks!

3 REPLIES 3
ShankerV
17 - Castor

Hi @dtrix 

 

As per the existing feature (common understanding), sort tool will sort the entire data based on the column used for Sorting.

 

If not, you are noticing a different behavior, then Can you please share the sample to explore more on your use-case.

 

Sample:

Before sorting

Student_IDName
9Sam
2Ram
3Subash

 

After sorting based on Student_ID

Student_IDName
2Ram
3Subash
9Sam

 

Many thanks

Shanker V

peterr_h
8 - Asteroid

Hello!

 

As per the previous response, the sort tool should sort the entire dataset based upon the fields (columns) configured within the tool.

 

Could you please attach an example workflow to show the tool not working as you are expecting?

 

Cheers!

dtrix
7 - Meteor

Thanks everyone! As you all mentioned Sort tool should sort all the data, I tested and it does. There was an issue with Find and Replace and returning incorrect/mismatched data. Rookie mistake.

 

Labels