Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Access

Import fixed width data tables into Spotfire

Sometimes source data tables are in the format of fixed width, no delimiter being used. Below is an example. Each field has a fixed width of 3 characters, but no delimiter. a def gh abc def g ab de ghi Importing data like this into Spotfire, there...
about 4 years ago in Spotfire / Data Access 2 Future Consideration

Automatically suggest joins in Information Link.

Spotfire should automatically suggest joins, when columns from different tables are added to the Information Link. We want Information Designer to be smart enough to suggest the joins already created, that are required on the Information Link, whe...
over 8 years ago in Spotfire / Data Access / Information Services 0 Future Consideration

Depivot in Information Link

It should be possible to do a depivot in an Information Link.
over 8 years ago in Spotfire / Data Access / Information Services 0 Future Consideration

Data Type of Column that starts as Int but later contains strings doesn't read the strings

Hi, In the situation where a column in an excel file contains strings and integers but starts with integers, the data type of the column read into Spotfire is integer. It can't be changed from within Spotfire to read string and read in the string ...
over 8 years ago in Spotfire / Data Access 0 Future Consideration

import txt files with fix size columns

Spotfire import txt file with delimiters only, if you have a file with fix columns size you need to transform it before. I know this file format is not traditionnal but when it is needed I use another tool to change the format
over 8 years ago in Spotfire / Data Access 0 Future Consideration

SharePoint Online connector should be able to load Likes and Star Ratings from lists

With SharePoint Lists you can set up rating with voting resp. star rating. https://support.microsoft.com/en-us/office/add-a-ratings-feature-to-your-library-5901fcfd-19ca-4f27-a65f-284654298552 Theses number of likes or average of star rating are n...
over 4 years ago in Spotfire / Data Access 0 Future Consideration

Control Order for data table loading

I have not seen an idea requested or the functionality in Spotfire, but feel free to correct me if the functionality exists. My dashboard is populated using a series of Information Links and Data Connectors. One of my data connectors is dependent ...
over 8 years ago in Spotfire / Data Access 0 Future Consideration

Show name of data table being processed in open file progress dialog when opening an analysis

Most of my analysis files use a lot of different data sources. Some take a long time to load - not a problem as I run them once a day. But it would be very nice to see at which data table he's working on instead of just "Opening connection to data...
over 8 years ago in Spotfire / Data Access 1 Future Consideration

Exclusionary Filters/Prompts for Data Sources

It is already possibility to filter or provide prompting when loading data from an information link or even from other database sources. However, these filters are limited to POSITIVE matches (single select, range, multi-select, etc). It would be...
over 8 years ago in Spotfire / Data Access 0 Future Consideration

Script/ shortcut-button to rebuild spotfire using data table properties "Source information" (can edit this table to remove old column etc.)

this is to lessen re-creating file following the data table properties source information, currently using this as reference by re-creating a damage file, no data on table due to missing column reference file but really long to do, especially for ...
almost 9 years ago in Spotfire / Data Access 1 Future Consideration