How to: Add Columns to a Mining Structure

Use Data Mining Designer in Business Intelligence Development Studio to add columns to a mining structure after you have defined it in the Data Mining Wizard. You can add any column that exists in the data source view that was used to define the mining structure. 


You can add multiple copies of columns to a mining structure; however, you should avoid using more than one instance of the column within the same model, to avoid false correlations between the source and the derived column.

To add a column to a mining structure

  1. Select the Mining Structure tab in Data Mining Designer.

  2. Right-click the mining structure and select Add a Column.

    The Select a Column dialog box opens.

  3. Under Source table, select the table in the data source view where the column resides.

  4. Under Source column, select the column that you want to add to the mining structure.

  5. Click OK.


If you add a column that already exists, a copy will be included in the structure, and the name appended with a "1". You can change the name of the copied column to something more descriptive by typing a new name in the Name property of the mining structure column.

Community Additions