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

[dtrix]

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!

[ShankerV · Accepted solution]

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_ID	Name
9	Sam
2	Ram
3	Subash

After sorting based on Student_ID

Student_ID	Name
2	Ram
3	Subash
9	Sam

Many thanks

Shanker V

[peterr_h]

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]

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.