Forum Discussion

Gazzer's avatar
Gazzer
Icon for Resolver II rankResolver II
9 years ago
Solved

Sort using the Sort by Column Button not Working

I am trying to sort a simple table of data using the Sort by Column button on the Modeling ribbon (and the one on the Modeling tab). I can never get it to work. I have followed the steps from the dir...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Gazzer

     

    Hi, Using your sample:

     

    Select Description from Field Panel after that go To Sort By Column and Choose Index.

     

    And Voila!!!. 

     

    Like this:

     

     

    Victor

    Lima - Peru

     

     

Gazzer's avatar
Gazzer
Icon for Resolver II rankResolver II
9 years ago

I want to sort by the 'Index' column, but without including it in the display table, as per below. The data is currently sorting by the Description column.

 

shill1000's avatar
shill1000
Icon for Helper IV rankHelper IV
9 years ago

I've tested this with simple sample data and it works fine - suggests the issue may lay in your data?

 

I created a query from the Excel file on the right, in which I sorted by the ID column. I then applied the 'Sort by Column' using the index column successfully, in the visual.

 

  • Gazzer's avatar
    Gazzer
    Icon for Resolver II rankResolver II
    9 years ago

    I have tried duplicating your sample, creating an Excel file, but it still does not sort. The only way I can get something which looks like what you have is to include the Index column in the display table and then reduce its width to zero so that it cannot be seen.

     

    I appreciate your persistence with this!

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    9 years ago

    Gazzer

     

    Hi, Using your sample:

     

    Select Description from Field Panel after that go To Sort By Column and Choose Index.

     

    And Voila!!!. 

     

    Like this:

     

     

    Victor

    Lima - Peru

     

     

  • Gazzer's avatar
    Gazzer
    Icon for Resolver II rankResolver II
    9 years ago

    Thank you Victor (and others) - the issue was me misreading the instructions. I was selecting the Index field in the list instead of the Description field.

  • shill1000's avatar
    shill1000
    Icon for Helper IV rankHelper IV
    9 years ago

    Very strange! Only thing I can think of is to check the datatype. In the sample, if you replcated exactly what I did, what datatype shows for each fo the 4 columns? Should be, in order, Index = Whole Number, ID = Text, Name = Text, Age = Whole Number. If any are a different data type that could be your issue. As you appear to be taking in data with German as he language I wonder if it is confusing the type detection? May have to update each type manually after import?

  • Gazzer's avatar
    Gazzer
    Icon for Resolver II rankResolver II
    9 years ago

    Not sure where you got German from - it is all English and typed in by hand, not imported. The index column is data type of whole number (as can be seen from my screenshot).

     

    I did not copy your data - in my sample file there is only two columns - the numeric index and the text description, which I did to make it as simple as possible (again, visible in the screenshot).

     

    Not sure where to go with this now - thanks for trying to help.

  • shill1000's avatar
    shill1000
    Icon for Helper IV rankHelper IV
    9 years ago

    Sorry I got two threads mixed up! 

     

    Just for the sake of sanity, can you try it using the same data as my sample and see if you get the same results? I think you need to rule out th esource data as a cause.