Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to sort the column?

Hi!   I have a column, text type as follows:   before 200001 200001 200002 200003 200004 ...... 202210   Please help me how to sort them so that before 200001 is on the first place. Thank...
Need Help
  • mangaus1111's avatar
    mangaus1111
    3 years ago

    Hi Anonymous ,

     

    insert in your data model a sort table like this and make a relatiosnship between the 2 columns

    Don´t forget to sort the Column Text in the Sort Table by the Index Column.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

mangaus1111's avatar
mangaus1111
Solution Sage
3 years ago

Hi Anonymous ,

 

insert in your data model a sort table like this and make a relatiosnship between the 2 columns

Don´t forget to sort the Column Text in the Sort Table by the Index Column.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.