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...
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...
Merge columns even if the data types are different.
When merging columns (data joins), even if the column names are the same, they won't be automatically matched if the data types don't match. When there's a large amount of data, setting each column individually can be time-consuming, so we'd like ...
Current, in the data analysis flyout, I need need to scroll through the entire list of columns to find the one I want to select or edit. This becomes inefficient when working with wide datasets containing dozens or hundred of columns. Previously, ...
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...
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...
Ability to copy/edit Data Source Information steps to another spotfire report with same data tables
Would be helpful if there is a option to copy all the steps that are perform in one data table when we dot Edit > Data Table Properties > Source Information steps to another Spotfire report which has the same data tables
In many enterprise Spotfire deployments, reports connect to wide tables or views via JDBC or Infolinks, often bringing in 50–200 columns by default—even when only a fraction of these columns are actually used in visualizations, expressions, or scr...
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...