Forum Discussion

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
7 years ago
Solved

Sorting site names as per active order

Hi 

i have few list of sitenames which i need to sort the order of the sites which is active.

 

List:

Germany

Norway

Milan

China

Finland

south africa

Venezula

 

 

How to get the above order?

 

Please suggest.

 

Regards,

Rajendra

Need Help
  • rajendraongole1's avatar
    rajendraongole1
    7 years ago

    Hi

     

    I have resolved it.

     

    Created one new column and applied switch statement with 1,2,3,4,5,6.. and so on. and i have sort the column by sort by column mode. able to get the visual as per requirement.

     

    Thanks.

     

    Regards,

    Rajendra

3 Replies

  • DouweMeer's avatar
    DouweMeer
    Icon for Impactful Individual rankImpactful Individual
    7 years ago

    Not sure if this 'solution' is the solution that matches your problem...

    But under the tab 'Modeling' you can find 'sort by column'. If you would use this, the alfabetical order will be overruled by the sort that you request from another column. 

    • rajendraongole1's avatar
      rajendraongole1
      Icon for Super User rankSuper User
      7 years ago

      Hi

       

      I have resolved it.

       

      Created one new column and applied switch statement with 1,2,3,4,5,6.. and so on. and i have sort the column by sort by column mode. able to get the visual as per requirement.

       

      Thanks.

       

      Regards,

      Rajendra