Search Results

Editing column matching or other settings for added rows

If you have added rows from a different source to a data table, there may be occasions when you need to update the settings used for matching the data from different sources together. For example, a column used for matching linked data may have been renamed or removed in either of the sources.

Tip: In the Source view of the expanded data panel, you will see a red exclamation mark on the Added rows node, if the current settings need updates.

Prerequisites

Rows must have been added to a data table in the analysis. See Adding rows to a data table for information on how to add rows using Spotfire Business Author. You must have some data loaded in the analysis and the Data panel must be shown.

Procedure

  1. In the Data panel, make sure the data table where the rows were added 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.

  2. Click on the Expand data panel for tools and details button, .
  3. In the expanded data panel, click Source view.
    You may need to first click the Go to data table view link to be able to see the Source view button.
  4. In the Source view, click the settings button on the Added rows node.

  5. In the Settings for added rows dialog, verify that the column matching is still 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. If an earlier match is broken, click on the exclamation mark and select a new match, when possible, or remove the match.
    Tip: When adding rows, you will append new rows to the original data table. This means that you should probably try to match as many columns as possible.
  6. Optionally, if there are additional columns in the added data, you can select to include or exclude these columns under Include additional columns from new data by selecting or clearing the check box for each column.
    Note: If the data source from which columns were added can be reloaded, and new columns become available after a reload, then the new columns will automatically become included. If this was not desired, you may want to exclude new columns after reloading data.
  7. Optionally, change the settings under Identify origin of rows.
    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 column to add the information about where rows come from to an existing column.
    Note: If a previously used column has been removed or renamed, you may need to select a different option before you can choose a different, existing column here.
  8. When you are done, click OK.

Example: Editing added rows when matching is broken

In this example, rows have been added from Salesforce.com to a data table that was originally opened from a local Excel file. The local file was saved using the data loading setting "New data when possible" and it has been reloaded at some time, using Spotfire Analyst. Before the Excel file was reloaded it was modified; the name of the column used in the matching was changed. Therefore, the previous matching of columns is now broken, which is indicated with a red exclamation mark in the Source view:

To fix the broken match, first click the settings icon on the Added rows node. This opens the Settings for added rows dialog, and the broken match is indicated with red exclamation marks:

Click on the red exclamation mark and then click Remove match. Add a new match for the renamed column in the original data by clicking on the plus sign next to the new column name and selecting a matching column from the new data.