Adding rows to a data table
You can add rows from a different source to your current data table. Data can be added from local files on your computer, or from different types of data files that have been previously saved in the library using the Windows client. You may also have access to other data sources from where you can add data.
Even though data from different data tables often can be viewed in the same visualization, it may 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.
Data panel, make sure the data table where you want to add data is selected.
This step is only applicable if you have two or more data tables in the analysis. If this is the case, select the data table of interest from the drop-down list at the top of the Data panel, otherwise, go to step 2.
- Click on the Expand data panel for tools and details button, .
- In the expanded data panel, make sure that the Data table view is selected and click Add rows.
- Select data to insert rows from.
Add rows – match columns dialog, verify that the suggested column matching is valid, or edit the matching as desired. This is done by adding or removing matches between columns
From original data and
From new data.
Click on the plus sign and select a column from the list to add a match for one of the columns from the original data. Click on the x on a row to remove a match.
- Optionally, if there are additional columns in the added data, you can select to include or skip these columns under Include additional columns from new data by selecting or clearing the check box for each column.
Optionally, change the settings under
Identify origin of rows in a column.
Select Do not identify origin to skip this option, Create new column to add a new column with different values for data from the original source and data from the added source, or select Use existing to add this information to an existing column.
When you are done, click
Tip: You can go back and make changes to the settings for the added rows by following the steps in Editing column matching or other settings for added rows.
Example: Adding rows from Salesforce.com
In this example, data has already been opened from a local Excel file. In the expanded Data panel, go to the Data table view and click on Add rows:
Choose Salesforce.com 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 until you are satisfied.