Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Management

Showing 293

Casing clean-up recommendation

Add a recommendation to the data panel to clean up casing differences in a column similar to the existing spaces clean up recommendation. Display the recommendation when a column contains values that differ only in casing. When selected, add a tra...
about 3 years ago in Spotfire / Data Management 1 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...
almost 8 years ago in Spotfire / Data Management 1 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...
about 6 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 5 years ago in Spotfire / Data Management 0 Future Consideration

Force "always new data vs. stored data" selection on save

When working with Spotfire *.dxp file cooperatively, the collaboration is very often hampered by the fact, that Spotfire tends to save *.dxp files as “linked”=”Always new data” by default. That happens in particular when: Spotfire is used when ...
almost 5 years ago in Spotfire / Collaboration / Data Management 1 Future Consideration

Loading Selected Columns from large files

Currently, if you have a very large file with several worksheets and columns within those worksheets Spotfire must read every column in that file even if you're only using a handful of columns. This makes download and refresh times very long compa...
almost 5 years ago in Spotfire / Data Management 2 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 6 years ago in Spotfire / Data Management 0 Future Consideration

Have the ability to perform Virtualization of Data without leaving platform

Have the ability to perform Data Virtualization on the data sets without having to leave the platform.
over 1 year ago in Spotfire / Data Management 1 Already exists

Add a Licence to allow saving a DXP with Stored data

We have users working with very large datasets and we wish to stop them being able to save these files to the Spotfire library with the data stored in the dxp file
about 5 years ago in Spotfire / Data Management 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...
over 6 years ago in Spotfire / Data Management 0 Future Consideration