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.

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.

Note

If you add a column that already exists, a copy will be included in the structure, and the name appended with a "1".

See Also

Other Resources

Mining Structure Tab How-to Topics

Help and Information

Getting SQL Server 2005 Assistance