Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Management

Showing 301

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

keep the fractional part of TIME type from MySQL when importing via connector

One of our customer had the issue that the fractional part of TIME type from MySQL is lost when importing via connector, e.g. value in DB 01:02:03.45 is imported as 01:02:03 where fractional part .45 is lost. We have been told that this is by desi...
over 1 year 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 st...
over 5 years ago in Spotfire / Collaboration / Data Management 1 Future Consideration

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...
over 3 years ago in Spotfire / 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...
over 5 years ago in Spotfire / Data Management 2 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...
almost 9 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...
about 7 years ago in Spotfire / Data Management 0 Future Consideration

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
over 5 years ago in Spotfire / Data Management 0 Future Consideration

Display Row Counts instead of Data Size while loading Information Links in Spotfire Analyst

Previous versions (up to v7.5) of Spotfire Analyst had display of row numbers while loading Information Links in display window. Spotfire 7.11 shows loading of data in terms of data size being processed. This is not beneficial as Developer does no...
over 5 years ago in Spotfire / Data Management 1 Future Consideration