Reorder items based on multi column sort

Solved438 viewsTips and Techniquesreorder sorting
0

Is there a way to reorder items based on a multi-column sort. I’ve got a list of university courses that belong to departments and in turn faculties. Every so often names change, departments merge and courses can even move departments. I know I can reorder row by row or blocks of rows by using ctrl and the arrow keys but is there a way I can sort my data and then apply it across all views?

I’ve got an attribute matrix where for each row (course) I’ve got columns for department, faculty, level and so on. I can use the multi-sort option to list the courses by faculty>department>level>course and that work great. I go to another matrix and they’re just in the original order.

Any ideas how I can lock in the new order?

thanks

John

Tahir Answered question November 1, 2023
1

Hi jefcc,

Yes, it is possible to reorder items based on values via script. See basic version below. It should be clear that in a sorted matrix, Quantrix sees only original (unsorted) item position (index). You can check it by adding item with #category formula in the sorted matrix. So, concept of sorting and reordering somehow different. It is not an easy task, if you really would like to implement this script please contact me via email ttahirov@smartmodelingsolutions.com

Tahir Answered question November 1, 2023
You are viewing 1 out of 3 answers, click here to view all answers.

Latest Questions