Sorting after Transpose
Hello good miners.
I want to be able to sort data by column (not row) values. As I understand, I first have to use Transpose, then Sort and then Transpose again to to get back to the original data matrix with sorted values. So I need to go from this:
2,1,0
0,2,1
to this:
0,1,2
0,1,2
The three-operator sequence works in principle fine but after the first Transpose Sort only allows one special attribute (id) to be chosen. This attribute just contains the original column names which Sort then sorts alphabetically. How can I get the subsequent data rows sorted (as resultset after Transpose#1 does contain att1..att(n) values to sort by) ?
best, Harri
I want to be able to sort data by column (not row) values. As I understand, I first have to use Transpose, then Sort and then Transpose again to to get back to the original data matrix with sorted values. So I need to go from this:
2,1,0
0,2,1
to this:
0,1,2
0,1,2
The three-operator sequence works in principle fine but after the first Transpose Sort only allows one special attribute (id) to be chosen. This attribute just contains the original column names which Sort then sorts alphabetically. How can I get the subsequent data rows sorted (as resultset after Transpose#1 does contain att1..att(n) values to sort by) ?
best, Harri
Find more posts tagged with
Sort by:
1 - 1 of
11
in an example set, each row is linked together. So let's say you have the following example set:
Regards,
Marco