Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Management

Support extremely wide data sets

Spotfire is excellent when working with wide datasets that can contain thousands or even tens of thousands of columns. In some situations, datasets can be extremely wide with millions of columns, which sometimes causes performance and UX issues. I...
over 3 years ago in Spotfire / Data Management 0 Future Consideration

Add driver support for datetimeoffset datatype in Spotfire

Currently columns with datetimeoffset format are no available in information links when using MS SQL driver. Spotfire does not support the datetimeoffset datatype so any columns that have this format are "invisible" when accessing MS SQL databases...
over 5 years ago in Spotfire / Data Access / Data Management 0 Future Consideration

Dynamic searching of columns in calculated column transformation

Hi Supporters, Please find the attached template to reproduce the issue. And refer to the TIBCO Case Number 01453993 We have the below formula which is valid if you do it via Insert -> Calculated Column. But it's not valid if you do it via In...
over 7 years ago in Spotfire / Data Management 0 Future Consideration

Better Logic / Control over Column Name Changes

Hello, I've recently had a support case (Case#2463638) about unwanted column name changes when using the "add rows" feature in combining data sets. In discussions around that case, we documented some inconsistencies around column name changes that...
almost 2 years ago in Spotfire / Data Management 0 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...
over 9 years ago in Spotfire / Data Management 2 Future Consideration

Simple master data editor (edit data table)

Spotfire can store data in library but this data cannot be modified directly. In many cases user needs to create simple master data or mapping tables which are stored on local drives in excel or other formats. This has many drawbacks. Users can up...
almost 10 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...
almost 8 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....
almost 8 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 ...
almost 8 years ago in Spotfire / Data Management 2 Future Consideration

Define tables as staging or reporting

Not all tables that are created in a Spotfire analysis are there for reporting purposes. Some tables are only for transforming data or loading data. The content of these tables is in the end, when all the loading, calculating and transforming is d...
about 10 years ago in Spotfire / Data Management 1 Future Consideration