Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Management

Showing 299

Multiple Unpivot Transformations in One Pass

Sometimes, there might be a data table where certain columns come in pairings. For instance, if I have a scaled score in 3 subjects for a student, and then I have a percentile rank for the same 3 subjects for a student, the data is likely to come ...
almost 7 years ago in Spotfire / Data Management 0 Future Consideration

File load dialog needs to show total elapsed minutes

I am debugging several files and want to know how long they take to open. The file open dialog gives me a running tally of each operation but no summation of the total elapsed time. This requires me to pay attention for the entire load, and I'd ra...
over 1 year ago in Spotfire / 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 5 years ago in Spotfire / Data Management 0 Future Consideration

Duplicate Data Wrangling in Data Canvas

Hi, Now that there is so much editing capacity in the data canvass, it would be useful to be able to duplicate an entire data wrangling set and then make small edits in it as needed rather than starting from point zero to create something similar...
over 5 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...
about 7 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...
over 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...
almost 6 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 6 years ago in Spotfire / Data Management 0 Future Consideration

Join Table where Empty Values are Treated as Wildcards

When joining tables in Spotfire, add an option where empty values are treated as wildcards. There's the option for "Treat empty values as equal" but this would only return the case if both tables had empty values for the matched field. If the valu...
over 1 year 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 6 years ago in Spotfire / Data Management 2 Future Consideration