Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Management

Showing 290

In Column Properties > Sort Order, add "sort based on ..."

Add a fourth radio option. If selected we can use an expression to set the sort order based on other column(s) in the same table. e.g. my table has categoryName, categorySequence I would select the new option, and sort expression would simply be [...
over 5 years ago in Spotfire / Data Management 1 Future Consideration

Create a pivot transformation from a cross table

The Cross table in Spotfire is a nice way to visually build a pivoted data table. It would be great if it was possible to create a pivot transformation from the cross table (similar to how it is possible to create a filter transformation from a fi...
almost 5 years ago in Spotfire / Data Management 1 Future Consideration

Additional string function where you are able to change the rounding settings

Belongs to the article https://community.tibco.com/questions/rounding-issue-string-function. If you use a numeric column and convert the result to a string column, there are always only 2 decimals shown. For calculating P values you´ll need 4 dec...
about 7 years ago in Spotfire / Custom Expressions / Data Management 6 Future Consideration

limit rows with "OR" operations of "limit by marking" and "limit by expression"

There's two options to limit table rows, one is "limit by marking", the other is "limit by expression". When setting both, they work together as "AND". We ask to be able to make them work together as "OR"
over 3 years ago in Spotfire / Data Management / Visualization 0 Future Consideration

Add anti-join option as a Join type

For scenario where the unmatched portion of a data are to be retained.
over 1 year ago in Spotfire / Data Management 0 Future Consideration

Purge cached data when saving analysis

PROBLEM: When saving an analysis as a DXP or into the library, with the analysis Spotfire saves a snapshot of cached data from the data tables at the point in time that the developer initially loaded/refreshed them. Generally this could be desirab...
about 8 years ago in Spotfire / Data Management 3 Future Consideration

Allow column selection and filtering when loading a Library Data File (SBDF)

When using Information Designer, it's possible to use filtering to restrict the rows that are returned and to be very specific about the columns that are returned. We're seeing a significant increase in the use of Library Data Files (SBDFs) as dat...
almost 5 years ago in Spotfire / Data Management 4 Future Consideration

Match columns dialog: make it sorted / sortable

Dear Supporters, please make the entries in the match columns dialog box sorted or at least sortable. Regards,
over 5 years ago in Spotfire / Data Management 6 Future Consideration

Option to explicitly select the columns to include when inserting columns (rather than only exclude columns)

When inserting columns into a data table within Spotfire, the user selects the column(s) to include in the last window. However, what is actually happening behind the scenes is an Exclude Columns transformation where the columns the user hasn't se...
about 8 years ago in Spotfire / Data Management 1 Future Consideration

Add "Limit data using expression" functionality to data function input data

When specifying input data for a data function, I am missing the "Limit data using expression" function. The limit by filtering and/or marking is there - but not the expression? This would really help limit the number of records sent to R for proc...
about 8 years ago in Spotfire / Data Functions / Data Management 3 Future Consideration