In Spotfire, what is the cause or reasons for a Data Table to become Embedded and Prevents Switching Back to "Linked"?

In Spotfire, what is the cause or reasons for a Data Table to become Embedded and Prevents Switching Back to "Linked"?

book

Article ID: KB0137480

calendar_today

Updated On:

Products Versions
Spotfire Analyst All Versions

Description

Spotfire allows users to load data as either linked (maintaining a connection to the source) or embedded (storing the data within the analysis file). However, certain actions can cause a linked data table to become permanently embedded, preventing it from being switched back to linked.  
 
The primary reasons for this behavior include:  
  1. Freezing a column
  2. Adding non-linkable data (e.g., clipboard data) 
  3. Saving and reopening an embedded table

 

Environment

All

Resolution

To prevent a linked data table from becoming permanently embedded, consider the following best practices:  
  1. Once a column is frozen, it alters the data table's structure, making it non-revertible to a linked state. So, avoid freezing columns in linked data tables if you need to maintain the link.  

  2. If clipboard data or any other non-linkable source is added to a linked data table, the table may still remain linkable initially. However, switching the table to embedded mode and saving the analysis and re-opening, will prevent it from being toggled back to linked. So, Be cautious when adding clipboard or non-linkable data to a linked table. If non-linkable data is required, consider keeping it in a separate table.  

  3. Once a data table is manually switched to embedded mode, saved, and reopened, the option to revert it to a linked state is lost. So, Ensure that the table remains linked before saving if you need to preserve the connection to the source.  

Restoring an Embedded Table:

If a data table has already been embedded and cannot be toggled back to linked, the only solution is to reload the data from the original source. You may also need to reapply any transformations, calculations, or custom modifications that were previously configured.

 

Issue/Introduction

In Spotfire, a data table that was originally linked to an external data source may become embedded under certain conditions, preventing it from being toggled back to a linked state. This article explains the possible causes and provides guidance on avoiding this issue. 

Powered by Wolken Software