Forum Discussion
Matrix Column sort following an IF statement
Hello astorey1
The easiest way to do this is by creating a new column that represents your sort order and use the "Sort by column" option in the modelling ribon.
Overdue Status = IF([Due Date]<TODAY(),1, IF([Due Date]-30<TODAY(), 2, 3))Kind regards
Joren Venema
Data & Analytics Consultant
If this reply solved your question be sure to mark this post as the solution to help others find the answer more easily.
Following are the steps:
Sort each row of the matrix.
Get transpose of the matrix.
Again sort each row of the matrix.
Again get transpose of the matrix.
Algorithm for sorting each row of matrix using C++ STL sort():
for (int i = 0 ; i < n; i++)
sort(mat[i], mat[i] + n);
Algorithm for getting transpose of the matrix:
for (int i = 0; i < n; i++) {
for (int j = i + 1; i < n; i++) {
int temp = mat[i][j];
mat[i][j] = mat[j][i];
mat[j][i] = temp;
}
}
I hope this helps!
Regards,
Lewis
Tech-consultant