Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Management

Showing 293

use already loaded data for report level joins

When using Report joins to add columns, if the joining table is already loaded why can this not be used to provide the extra columns rather than load the table again.
over 5 years ago in Spotfire / Data Management 1 Future Consideration

Set On-Demand Input for Data Table Column with a Boolean Data Type

Currently it seems that, when setting a data table to load data "on-demand", it is not possible to set an input for data columns for the table that have a "Boolean" data type. I'm not sure if this is a bug, but it would be useful to be able to als...
about 4 years ago in Spotfire / Data Management 0 Future Consideration

Show "Last Reload" Date option at the bottom of the report next to the "Marked Row" section

Currently if you want to see the last reload data for data, you have to go into Data Table Properties and look at source information. I think it would be beneficial to have a visual queue easily found to show the date the data was last loaded..whe...
almost 7 years ago in Spotfire / Data Management 1 Future Consideration

insert rows - add option to show only unmatched after match all possible

on inserting rows, after matching all possible, could you provide a button to allow seeing all matched and unmatched, as today, or to show only unmatched... with long param name lists its annoying having to scroll through all the already matched n...
about 4 years ago in Spotfire / Data Management 0 Future Consideration

Store calculated columns in data connections

If you have a lot of calculated columns in your analysis file, it's frustrating that the only way to share these is by duplicating the analysis file. If they could be stored in data connections these could be reused across multiple dashboards. The...
over 5 years ago in Spotfire / Data Access / Data Management 0 Future Consideration

Add an Ignore Zeros option in an Unpivot transformation

I often have a table with a large number of zero values ( rather than null values) in soem columns that I then need to Unpivot. This results in a table with a large number of rows where the valu column is zero and this impacts overall performance....
over 5 years ago in Spotfire / Data Management 0 Future Consideration

Split a column into rows

I have a column with multiple values inside, with a separator between each value. The number of values is not the same on every row. If I use the standard split column feature, I will generate a number of columns corresponding to my max number of ...
over 5 years ago in Spotfire / Data Management 2 Future Consideration

Data wrangling function to merge multiple dataframes to fill and replace

Often, multiple sources of data have different level of 'complete cases' - dataset #1 may have 60% filled entries, while dataset #2 may have the remaining 20% that are missing from #1 (both datasets may have all or some columns matching). Currentl...
about 7 years ago in Spotfire / Data Management 2 Future Consideration

Ability to replace empty cells by a value in PIVOT transformation

When pivoting tall tables to make them wide, we end up with lots of empty cells that correspond to combinations that do not exist in the original tall data set. It is now very difficult to replace these empty values by a valid value (like 0) ... s...
almost 6 years ago in Spotfire / Data Management 0 Future Consideration

Option to release temporary data from memory when using "Add Rows" and "Add Columns" operation.

At this time, when using "Add Rows" and "Add Columns" operation, memory consumption becomes much larger than total of each data source. For example, four data sources with 1000 rows each are merged in one datatable with "Add Rows" operations, bel...
about 3 years ago in Spotfire / Data Management 0 Future Consideration