Data Management

Showing 302

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

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

4 VOTE

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

about 6 years ago in Spotfire / Data Management 2 Future Consideration

5 VOTE

Data wrangling function to merge multiple dataframes to fill and replace

Often, multiple sources of data have different level of 'complete cases' - dataset #1 may have 60% filled entries, while dataset #2 may have the remaining 20% that are missing from #1 (both datasets may have all or some columns matching). Currentl...

over 7 years ago in Spotfire / Data Management 2 Future Consideration

3 VOTE

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

5 VOTE

Simple master data editor (edit data table)

Spotfire can store data in library but this data cannot be modified directly. In many cases user needs to create simple master data or mapping tables which are stored on local drives in excel or other formats. This has many drawbacks. Users can up...

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

4 VOTE

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

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

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

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

Please enter your email address

FILTER BY CATEGORY