Add Columns to a Mining Structure

Applies to: SQL Server 2019 and earlier Analysis Services Azure Analysis Services Fabric/Power BI Premium

Important

Data mining was deprecated in SQL Server 2017 Analysis Services and now discontinued in SQL Server 2022 Analysis Services. Documentation is not updated for deprecated and discontinued features. To learn more, see Analysis Services backward compatibility.

Use Data Mining Designer in SQL Server Data Tools 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.

Note

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.

Note

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.

See Also

Mining Structure Tasks and How-tos