Sorter and ListSorter to sort multiple attributes with numeric values

Welcome to the FME Community @benadei! It will be really helpful if you explain what you have tried so far, what errors/results you are getting. Screenshots are always helpful, or providing your workspace and sample data is even better if possible. This guide for New FME Community users provides useful tips on how to best engage with the FME Community.

To your question, the Sorter should allow you to add multiple attributes by clicking on the + button in the Sorter's parameters dialog:

If you are working with list attributes, you might have to string together multiple ListSorter transformers one after another? I hope this helps.

Note that the ListSorter does not currently support sorting by multiple attributes, even if you chain one ListSorter after one another. This is a known limitation, so please consider voting for this idea:

https://knowledge.safe.com/content/idea/72018/listsorter-to-support-multiple-sort-by-criteria.html

Sorry @benadei, could you possibly illustrate what your desired result is? I I could be misunderstanding your intended results.

In my experience, sorting multiple attributes using the Sorter works like so... If you have:

Then if you sort it by the first, second, and third columns in ascending order, respectively, you would get the following:

I hope that makes sense. I've attached a quick workspace template that illustrates this idea: sortmultiple.fmwt

Hi @nampreetatsafe! Thanks for taking the time to respond again. Sorry if I have not been very clear in the results I am looking for, but is it possible to sort all columns or attributes independently in ascending order for example to get the result below instead?

1 2 6

Thanks for taking the time ebygomm!

Ok, thanks @ebygomm! Is there a way of splitting the attributes and sorting each of the individual attributes as separate features?

Here's a reworked workspace demonstrating one possible approach using only 3 attributes: sortmeindividually.fmwt I used an AttributeKeeper to isolate an attribute, ran it through the Sorter, then through a Counter to help with rejoining the attributes back together after they are sorted.

As @ebygomm mentioned earlier, you may want to consider using looping custom transformer or python to help process the 52 attributes. But I'm hoping this helps you with the general concept.

Thank you so much! I will try your newest suggestion. Have a good weekend.