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
Guest
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
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.
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.
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...
It would be extremly usefull to have this Transformation "Sort Table by Column" and reindix this table after the new physical order
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.
Tha Add Column transformation with Left Single Match join it will be benefited with Add Sort Column Transformations as well.