Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Management

Showing 304

Enhancement Request - Officially Support use of IN Operator

Request for Spotfire to "officially" support the use of the IN operator in the Spotfire Expression Language. For example:CASE WHEN COLOR IN ('RED', 'BLUE', 'GREEN') THEN TRUE ELSE FALSEEND I've written code that uses IN () and it *appears* to work...
over 8 years ago in Spotfire / Data Management 2 Future Consideration

Embed only filtered rows

We would like the ability to embed only filtered rows. This option is currently available when exporting data, but not for embedding. This would allow authors to save and share analyses built from all-encompassing information links with authors wh...
over 8 years ago in Spotfire / Data Management 0 Future Consideration

Define tables as staging or reporting

Not all tables that are created in a Spotfire analysis are there for reporting purposes. Some tables are only for transforming data or loading data. The content of these tables is in the end, when all the loading, calculating and transforming is d...
over 8 years ago in Spotfire / Data Management 1 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...
over 8 years ago in Spotfire / Data Management 1 Future Consideration

Simple spreadsheet capabilities

In some cases it would be very useful to have simple spreadsheet capabilities built into Spotfire. Something like the current table view, but with the ability change to values of rows/columns (available e.g. only for embedded data). This would go ...
over 8 years ago in Spotfire / Data Management 1 Future Consideration

Combination of filters using and, or, xor, not etc.

In many cases it is useful to have a filter where a row filtering should depend on two columns. An example would be to select all rows with country equal to UK or Year before 2010. This is currently not possible without using a calculated column w...
over 8 years ago in Spotfire / Data Management 4 Future Consideration

Setting for Case sensitivity

Currently Spotifire is Case Sensitive which makes aggregations at certain level harder to manage. While you can do all sorts of string manipulation it would be nice to have a setting to turn on/off case sensitivity. For example , if you aggregate ...
over 8 years ago in Spotfire / Data Management 1 Future Consideration

Enable "Replace Data Function" if a new .sfd is available

Say I have a data function (e.g. TERR) embedded within a Spotfire file. An updated copy of that data function becomes available as an .sfd file (maybe I sent a copy of the Spotfire dxp to a colleage, or to a different VM environment, and an improv...
over 8 years ago in Spotfire / Data Functions / Data Management 0 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...
over 8 years ago in Spotfire / Data Functions / Data Management 3 Future Consideration

Import/Export calc columns in Spotfire

It would be great, If we have import/export option in Column properties. This option required only for calculated column. It should allow to export calc columns and expression from DXP. And also, able to import calculated column from another DXP. ...
almost 9 years ago in Spotfire / Custom Expressions / Data Management 1 Future Consideration