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

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!

Common Use Cases

Accepted answers

ShankerV

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

All comments

ShankerV

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703