Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Management

Showing 293

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

Greater/lesser than Join Types (like SQL)

When creating a column add (aka join) between tables, it would be amazing to be able to more specifically define the join type rather than only having an '='. If for example you could select the type from =, >, <, >=, <=, etc. then you...
about 2 years ago in Spotfire / Data Management 0 Future Consideration

Change default insert columns behavior

The way that the Spotfire insert columns mechanism is built is it builds a list of columns to ignore, rather than a list of columns to insert. For example, let's say you have Table A with column A, B, and C. You insert column A into Table B. Then,...
over 3 years ago in Spotfire / Data Management 1 Future Consideration

Add transformations to external data tables (and database pushback of these)

Spotfire lacks one very important feature to make data preparation more useful: basic operations on external tables. Other tools offer this in terms of joins, filters for row and columns, simple calculations, aggregation and similar. All these ope...
about 3 years ago in Spotfire / Data Management 0 Future Consideration

Change format for multiple columns at once

After reading data into Spotfire I sometimes have several columns that I want to change formatting for. E.g. I may want to change all columns containing revenue to currency formatting with a thousand separator. Today I need to select each column o...
7 months ago in Spotfire / Data Management 0 Future Consideration

Add ability to automatically sync data-source changes

Hello, I would like to request the ability to have Spotfire files automatically update if the data source table changes. Right now if there is a change to the data source, it requires a user to go into each file that is connected to the data sourc...
about 2 months ago in Spotfire / Data Management 0 Future Consideration

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
about 4 years ago in Spotfire / Data Management 3 Future Consideration

give the infoLink builder in information designer the look and feel of the data canvas

The infoLink builder interface is now highly technical in look and feel while there is a very nice interface with virtually the same functionality available in the data canvas. This would greatly help the self service use of the tooling. Please co...
almost 5 years ago in Spotfire / Data Management 9 Future Consideration

Custom expression when performing unpivot/pivot data transformation

It would be useful to have the possibility to use custom expressions in pivot transformations. This would allow users to already create tailormade columns during the transformation phase, rather than once the data is loaded completely.
about 4 years ago in Spotfire / Data Management 0 Future Consideration

Copy and Paste Transformations From One Data Table to Another Data Table

When I want to move a transformation (or many transformations) from one data table to another data table due to similar characteristics between tables (or any other reason), it would be easier to move by copy/paste rather than to recreate the same...
about 1 year ago in Spotfire / Analytics / Data Management 1 Future Consideration