Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Management

Showing 293 of 4232

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...
over 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,...
almost 4 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

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

Ability to add in conditions when joining data in Spotfire Cloud such as >, <, <=, >=

When inserting columns in Spotfire Cloud (desktop version) the data tables can only be joined on exact matches (=). It would be useful to be able to add in conditions such as > or <= to narrow down the number of matches to the desired row in...
about 5 years ago in Spotfire / Data Management 3 Future Consideration

Sort table columns directly in data canvas

No description provided
almost 3 years ago in Spotfire / Data Management 1 Future Consideration