Multi-level sorting

20155127011

I have a table something like this:

Column A	Column B	Column C
Jane Doe	A1	1
Jane Doe	B2	2
John Doe	A1	1
John Doe	A2	2
John Doe	B1	1

 

I need to sort this table firstly Column A then Column B then Column C.  I can do this in Excel like this:

 

I tried to chain multiple sort operators but it didn't work.

land

Hi,

you could simply install the Jackhammer Extension from Marketplace and use the Advanced Sort operator which allows to specify multiple attributes. You don't need a license file for this particular operator.

 

Otherwise chain multiple Sort operators in inverse order of their significance. Least important one sort first, then the next, etc. But is much more ugly and also slower than a single Sort (Advanced) Operator of the Jackhammer.

 

Greetings,

 Sebastian