To insert columns from file:
Select Insert > Columns....
If you have more than one data table in the document, select which data table to add columns to, then click Next.
Click the File radio button.
Click Browse... to locate the file to add columns from, then click Open.
Response: If the selected file is a text file, the Import Settings dialog is displayed. If the selected file is an Excel file, the Excel Import dialog is displayed. Optionally, make the desired adjustments in the dialog, then click OK.
Apply transformations (optional).
Comment: See Transforming Data to learn more.
Click Next > to go to the Match Columns step of the wizard. (If you want the columns to be matched automatically, go straight to step 11 instead.)
Click on the Match All Possible button, or manually select one column From current data and one From new data and click Match Selected. Repeat if necessary.
Comment: The columns used for matching should together create a unique identifier for all rows.
Click Next > to go to the Import step of the wizard.
Select the columns that you wish to add from the new data.
Select a Join method to determine which rows to keep from both data tables.
Comment: Note that selecting an inner join may result in that no data remains in TIBCO Spotfire, if no matching rows are found.
Click Finish.
Response: The selected columns are added to your data table.
To insert columns from an information link:
Select Insert > Columns....
If you have more than one data table in the document, select which data table to add columns to, then click Next.
Click the Information Link radio button.
Click Browse... to locate the information link to add columns from.
Response: The Select Information Link dialog is displayed.
Locate and select the information link of interest, and then click OK.
Apply transformations (optional).
Comment: See Transforming Data to learn more.
Click Next > to go to the Match Columns step of the wizard. (If you want the columns to be matched automatically, go straight to step 12 instead.)
Click on the Match All Possible button, or manually select one column From current data and one From new data and click Match Selected. Repeat if necessary.
Comment: The columns used for matching should together create a unique identifier for all rows.
Click Next > to go to the Import step of the wizard.
Select the columns that you wish to add from the new data.
Select a Join method to determine which rows to keep from both data tables.
Comment: Note that selecting an inner join may result in that no data remains in TIBCO Spotfire, if no matching rows are found.
Click Finish.
Response: The selected columns are added to your data table.
To insert columns from a database:
Select Insert > Columns....
If you have more than one data table in the document, select which data table to add columns to, then click Next.
Click the Database radio button.
Click on Browse... to locate the database with additional data.
Response: The Open Database dialog is displayed.
Follow the instructions for the desired data source type under Opening Data from a Database.
Apply transformations (optional).
Comment: See Transforming Data to learn more.
Click Next > to go to the Match Columns step of the wizard. (If you want the columns to be matched automatically, go straight to step 12 instead.)
Click on the Match All Possible button, or manually select one column From current data and one From new data and click Match Selected. Repeat if necessary.
Comment: The columns used for matching should together create a unique identifier for all rows.
Click Next > to go to the Import step of the wizard.
Select the columns that you wish to add from the new data.
Select a Join method to determine which rows to keep from both data tables.
Comment: Note that selecting an inner join may result in that no data remains in TIBCO Spotfire, if no matching rows are found.
Click Finish.
Response: The selected columns are added to your data table.
See also:
Details on Insert Columns – Select Source
Details on Insert Columns – Match Columns
Details on Insert Columns – Import