Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Data Management
Created by Guest
Created on Apr 18, 2020

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
  • 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

Merged
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.
almost 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

Merged
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...
almost 4 years ago in Spotfire / Data Management 1 Future Consideration