Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Management

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...
about 8 years ago in Spotfire / Data Management 0 Future Consideration

Warning when Right or Left Join adds rows to data table

I think it would be great if Spotfire would warn me when an insert column operation will add rows to the data. Sometimes this is intended, but other times, it is because there is a problem in the data quality. In my use case, adding rows is usuall...
over 8 years ago in Spotfire / Data Management 0 Future Consideration

Create a way to identify and/or clean up unused objects in Spotfire DXP (Calculated columns, Property Controls)

This could be a multi-level feature: Option 1 – Flag whether the column/ Property Control is used in any other Column, Property Control, Viz, Data function Answers the question: will something in the report break if I delete this object? Example:...
over 8 years ago in Spotfire / Data Management 1 Future Consideration

Provide useful information on why refresh is disabled, when this is disabled for a data table, so that the developer knows how to resolve his or her issue.

When and if the refresh button is disabled, we should clearly list why this is the case. Be it circular dependencies, frozen columns, or anything else. As it is now it is almost impossible for a report developer to find the cause by themselves. At...
over 10 years ago in Spotfire / Data Management 0 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...
over 6 years ago in Spotfire / Data Management 0 Future Consideration

Show Calculated Columns Precedents and Dependents

When making several calculated columns that refer to other columns it would be useful to see a branch out of all the columns that go into a calculated column. Also, the ability to see the columns that are dependent on the calculated column would h...
over 8 years ago in Spotfire / Data Management 0 Future Consideration

Allow Node Labeling in Data Canvas

Part of code documentation is following the sequence of logic used to build a data table. While calculated expressions support double-slash comments, not every node requires a calculated expression. Being able to add a comment / annotation to the ...
about 2 years ago in Spotfire / Data Management / User Experience 0 Future Consideration

Capability to apply "TRIM" to multiple columns simultaneously

It would be useful to have a transformation that would apply the "TRIM" function to multiple columns at the same time. This is useful because when joining data tables, the text of the columns must match exactly. Therefore, TRIM is often applied to...
almost 9 years ago in Spotfire / Data Management 0 Future Consideration

Log entry for which user used "Replace Value" function

Hi, Recent version of Spotfire 7.9 came with a cool feature, enabling users to replace values on table views. Data Panel source view has an entry for this type of transformation but it does not have any information about which user did the chang...
over 9 years ago in Spotfire / Data Management 0 Future Consideration

Quickly transform data using Python or R

The Spotfire Data Canvas should support transforming data with Python or R code that's added directly to the data canvas pipeline. With a couple of clicks you should be able to paste your Python or R code directly into a new data function which is...
almost 7 years ago in Spotfire / Data Management 0 Future Consideration