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...
Split a data table into two or more data tables based on expression
I need to split a data table into two or more data tables based on logic I can provide as an expression. I know I can do this using a few steps and filter transformations in the data canvas, but would ideally want to be able to do this in one plac...
add option to enable datatable color stripe as default
In Document properties, there's an option of "Show a color stripe for related tables". This color stripe is useful when loading multiple datatables, but it's disabled as default. Please add option to enable datatable color stripe as default.
Customer would like to be able to reload on-demand data incrementally. E.g. if condition A/B/C/D are marked and data are loaded based on that, (1) when changing marking to A/B/C/D/E, only load data E and append to current dataset (2) when removing...
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,...
Sometimes the user needs only 4-5 columns in a dataset from a file or database containing hundreds of columns. When importing into Spotfire, the Import Settings menu does not allow the user (in Spotfire X at least) to select all/ deselect all fiel...
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
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...
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...
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...