Skip to Main Content
Spotfire Ideas Portal
Status Implemented
Product Spotfire
Categories Data Management
Created by Guest
Created on Oct 15, 2017

When replacing data table - provide option to redo Inserted Columns

I often have to replace a data table with another one.  It seems Spotfire drops any columns which were added to the original table via Insert Columns.  This means I have to recteate the Insert Columns actions again to completely replicate the table I am replacing.

Spotfire should ask me if I would like to repeat the Insert Columns action, so when replacing a data table - I end up with the same end state (should I wish) including all transformations applied.

After all - when replacing a data table, my calculated columns still stand - why make an assumption I don't need my Inserted Columns again. 

An example for me personally, is I receive an Excel file of a Business Objects report each month.  For various reasons, I replace this data table from the Clipboard.  Every time I do this, I lose a column I have inserted which enables me to map the countries in the report, to countries Spotfire understands for geoanalytics.  I have to re-perform Insert Columns every month to add this country mapping column.  Why drop Inserted columns when replacing a data table?

Implemented in 7.11
  • ADMIN RESPONSE
    Nov 20, 2017

    With Spotfire 7.11 you can replace a data source (instead of only the full final data table) and also add transformations to existing data sources.

  • Attach files