Changes in Spotfire version 10: How to add Rows or Columns to your existing data in Spotfire 10

Changes in Spotfire version 10: How to add Rows or Columns to your existing data in Spotfire 10

In TIBCO Spotfire client versions before 10, you could add columns and rows from the Insert menu. From version 10, rows and columns are now instead added either from the Files and data flyout or via the Data canvas. Columns and rows can be added to your data table in the following ways:

Alternative 1:
1. Click on the Files and data flyout in the upper left corner of the Spotfire client.



3. Select the data you wish to add.
4. If needed, click the Settings icon (the cog wheel) in order to change matches and/or joins, and click on "Transform data" if you want to transform (e.g. pivot) the added data.
5. Click OK.

Note 1: Not only can you add new data to your analysis in this way, but when selecting what data to add in the two alternatives documented above, listed under the "Other" option you will also find your existing data tables in the analysis, allowing you to add rows/columns from one existing data table to another.        

Note 2: For more information on how to edit column matching when adding rows and columns in Spotfire 10 and higher, please see article 000037097. Doc: How to Add Columns

• https://docs.tibco.com/pub/sfire-analyst/11.4.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=add%2Fadd_how_to_add_columns.htm

Doc: How to Add Rows

• https://docs.tibco.com/pub/sfire-analyst/11.4.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=add%2Fadd_how_to_add_rows.htm

KB: How to Edit column matching when adding rows and columns in Spotfire 10

• https://support.tibco.com/s/article/How-to-Edit-column-matching-when-adding-rows-and-columns-in-Spotfire-10