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

Edit Add Columns (join) operations

It should be possible to edit Add Columns (joins) operations in TIBCO Spotfire.

Implemented in 7.13
  • ADMIN RESPONSE
    Jun 29, 2018

    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.

    https://community.tibco.com/wiki/whats-new-tibco-spotfire
    https://www.youtube.com/watch?v=Z_4LC8nYpV8

  • Attach files
  • Guest
    Reply
    |
    Jun 29, 2018

    awesome!

  • Guest
    Reply
    |
    Apr 19, 2018

    In 7.12 you can now delete an insert columns operation, so at least you can remove it and redo it.  It's not ideal, but it's a significant improvement.  We were upgrading to 7.11 and then ditched that when 7.12 came out.  That feature along would make the upgrade hassle worth it.

  • Guest
    Reply
    |
    Apr 19, 2018

    Needed. ON a complex analysis with joined operation between tables to find the only option is to recreate the analysis for changing conditions is frustrating, to say the least. Seems no option if you got it wrong the 1st time to fix it. (Using 7.11) Worse is that you CAN edit the data sources.

  • Guest
    Reply
    |
    Mar 27, 2018

    Thanks Mark! I have updated it. :)

  • Guest
    Reply
    |
    Mar 27, 2018

    Thomas, I guess it wouldn't hurt to edit this idea to say "It's not possible" rather than "It's now possible". Could potentially increase the votes and reduce confusion :-)

  • Guest
    Reply
    |
    Mar 27, 2018

    Had the same problem and it was confirmed that this feature is still not available as of today in 7.11 or 7.12 I guess.

  • Guest
    Reply
    |
    Oct 6, 2017

    I don't see any way to edit join operations in 7.10

  • Guest
    Reply
    |
    Aug 23, 2017

    Is this now part of 7.10?

  • Guest
    Reply
    |
    Jun 15, 2017

    Thomas, I have seen this in a couple of your other posts, but you are saying that a feature is available when it isn't yet available.  The most recent version is 7.9, and this is not part of that.  Can you please be more clear with stating what is and isn't part of the current applications.

    With that said, I would like to add that we also need the option to remove an Insert Rows or Insert Columns operation, in addition to the ability to edit it.  I added this as an idea and am upvoting this.