Adding rows to a data table
If you are working with imported (in-memory) data, you can add rows from a different source to your current data table. Data can be added from a local file, a data file previously saved in the Spotfire library (using the installed client), from data functions that produce data, from data connections saved in the library, or you can add data directly from Google Analytics or from Salesforce, if you have access to those systems. In the installed client you can also add data directly from other data sources using connectors, from information links, or from the clipboard.
About this task
Even though data from different data tables often can be viewed in the same visualization, it might be preferred to actually incorporate similar data into a single data table. For example, if all columns are the same in the data sources and you know that you want to use summarized values from all sources in your visualization.
You add data from the
Files and data flyout
or from the
Data canvas.
When you add data from the Files and data flyout, you can select to add the data as new rows in another data table from the final step in the add data workflow:

You can also insert rows into a specific place in a data table structure, as described below.
Before you begin
Procedure
Example: Adding rows from Salesforce
In this example, data has already been opened from a local Excel file. In the Data canvas, select the data table of interest, determine where you want to add rows (between the nodes in the graphical structure or between transformation groups), and click Add rows:

Choose a new or a predefined connection to Salesforce and sign in. Select the data to add and click OK. In the Add rows – match columns dialog, verify that the suggested column matching is valid, or add or remove matches between columns From original data and From new data. When you are satisfied with the data selection and settings, click OK to close the flyout and add the data.
- Editing column matching or other settings for added rows
If you have added rows from a different source to a data table, there might be occasions when you must update the settings used for matching the data from different sources together. For example, a column used for matching linked data can have been renamed or removed in either of the sources.