Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Sort a column by another column principle

Hi everyone, I have a table like this 

I would to visual a table with Parent_Index and Index as Column Label like this 

I want to sort weekday in order so I create the Order_id columns, but I can not sort Index Column by  Order_id columns

I just do not really understand why I am wrong and how to done it. 

I will be appreciated for your help. Thanks in advance!

 

 

 

  • lbendlin's avatar
    lbendlin
    2 years ago

    Add a composite key (Index+parent index) and change the order_id column to consecutive numbers across that composite key as needed.

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Add a composite key (Index+parent index) and change the order_id column to consecutive numbers across that composite key as needed.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      But when it comes for visualizing, I still want to use column "Index" and "Parent_Index" seperately for visual's column labels. Creating composite key and sorting it by distinct consecutive order_id seem not really help.