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