The Multiple Columns tab can be used if you want to create many column elements in one operation.
Note: Whole databases and schemas cannot be added, only columns and tables are available.
To add multiple columns to the information model:
In Information Designer, click New and select Multiple Columns.
Response: A Multiple Column Elements tab is opened.
In the Data Sources tree, select the column (leaf node) or table that you want to include.
Click Add >.
Response: The selected column is added to the Source columns list. If a table was selected, all columns in the table will be added to the list on the Multiple Column Element tab.
Comment: Repeat this step if you want to include more data columns.
Click on an element in the Source columns list and change its name by typing in the Column element name field (or go to step 8 to add the columns using the default settings).
Comment: This step is not necessary unless you want to change the name or description of the element.
If desired, change the description of each column element.
Comment: The description is metadata on the column which can be used in search expressions inside Spotfire.
Click Create Columns.
Response: The Create Multiple Columns dialog is displayed.
Click to select the folder where you wish to store the column elements.
Click Create Columns.
Response: The columns are stored in the specified folder in the library. Columns of type Unknown will be mapped to the data type String when they are added through the Multiple Columns tab. The data type can be changed later by editing each column element.
See also: