Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Data Management
Created by Guest
Created on Aug 1, 2016
Merged idea
This idea has been merged into another idea. To comment or vote on this idea, please visit SPF-I-5197 Option to explicitly select the columns to include when inserting columns (rather than only exclude columns).

Insert Column function. Merged

After Insert column of TableA to TableB, if I add a new column ( from Informatio Link or Calculated column and so on ..) in TableA are automatically added to a new column in TableB.

Currently this feature is as designed and New columns added to Information Links used in Insert > Column joins are added by default to data table.

I want to be the only additional columns I selected to TableB. So, In this case, I hope the  option to select or not, to add a column.

Implemented in 7.13
  • ADMIN RESPONSE
    Jun 29, 2018

    With Spotfire 7.13 you are now able to edit the insert column operations:

    Adding data to your analysis by inserting columns (joins) is a core part of data preparation. With Spotfire 7.13 now available you now have the alternative to add columns by using Spotfire's web client Business Author in addition to the Windows client Spotfire Analyst. This means more users will be able to do their visual data discovery in their web browser without installing Spotfire's Windows client. If you discover issues with your joins while using any of the clients you can also edit them.

    A new user interface based on Spotfire's recent Add Rows UI makes it really easy to understand the different join methods through illustrations. The result is previewed before finishing the edit. The UI is also smart. For example, it shortlists and recommends id and categorical columns that share name and datatype. This makes it quicker to find the columns you are most probably looking for.