Data Management

Showing 290

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...

over 6 years ago in Spotfire / Data Management 0 Future Consideration

1 VOTE

Marked Row DataTransformation in Data Canvas/IronPython API

Scenario Given a DataTable with marked rows, goal is to add a DataTransformation or other DataFlow step in Data Canvas or via IronPython API to obtain the said table containing only the marked records. Current approach uses a Data Function to get ...

over 1 year ago in Spotfire / Data Management 0 Future Consideration

5 VOTE

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

4 VOTE

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

1 VOTE

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

2 VOTE

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

3 VOTE

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

4 VOTE

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...

almost 7 years ago in Spotfire / Data Management 0 Future Consideration

2 VOTE

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

3 VOTE

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...

about 5 years ago in Spotfire / Collaboration / Data Management 1 Future Consideration

Please enter your email address

FILTER BY CATEGORY