You can insert columns from many different sources. Below are some examples of how to add columns from some of the most common sources.
Tip: Type the name of the data source directly at the top of the Select menu to search for a data source. The results are grouped after source origin to help you find the source from the correct location.
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.
Click Select > File....
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.
Click Select > Information Link....
Response: The Select Information Link dialog is displayed.
Locate and select the information link of interest, and then click OK.
If desired, select the check box and specify settings to Load on demand.
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 data connection:
Select Insert > Columns....
If you have more than one data table in the document, select which data table to add columns to.
Click Select > Connection To > [any of the available options] and provide any required information.
Response: If you select or create a data connection containing more than one view then the Select Data Table dialog is displayed. Otherwise, go to step 5.
Click on the desired data table 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.
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 Select > Clipboard.
If the clipboard contains a DXP, SBDF, or STDF file, the file path will automatically be added under Add columns from. If the clipboard contains data from an Excel file, the Excel Import dialog is displayed. If the clipboard contains data in text format, the Import Settings 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.
See also:
Details on Insert Columns – Select Source
Details on Insert Columns – Match Columns
Details on Insert Columns – Import