Skip to Main Content
Spotfire Ideas Portal

Add Sort Column Transformation

Some times, more complex expression containing the Previous function requires that the data table are in certain order, something not possible with actual version of Spotfire. So I suggest a new type of transformation

  • Attach files
      Drop here to upload
    • Guest
      Reply
      |
      Nov 14, 2022

      It would be extremly usefull to have this Transformation "Sort Table by Column" and reindix this table after the new physical order

    • Guest
      Reply
      |
      May 27, 2022

      The much-used First() and Last() Expression functions reference the physical order of the rows of data (in the Data Table). The proposed transformation would give some control over the order used by these functions.

    • Guest
      Reply
      |
      Apr 22, 2020

      Tha Add Column transformation with Left Single Match join it will be benefited with Add Sort Column Transformations as well.

    1 MERGED

    add transformation to sort data by 1 or more columns

    Please add transformation to sort data by 1 or more columns and also be able to specify sort order (asceding/descending) on each column. Many of my customers want to sort data by columns. Thanks.
    over 3 years ago in Spotfire / Data Access 0 Future Consideration
    1 MERGED

    Add a Sort Data transformation where the user can specify which column(s) to sort by

    Having a data table sorted by specific columns after loading can simpIify subsequent steps such as calculated coulmns and pivot and join transformations For example I am loading data from multiple sources using the add rows feature, but I then wis...
    over 4 years ago in Spotfire / Data Management 1 Future Consideration