| title | description | ms.date | ms.service | ms.custom | ms.topic | ms.author | ms.reviewer | author |
|---|---|---|---|---|---|---|---|---|
Exclude a Column from a Mining Model | Microsoft Docs |
Learn how to excluded a column from a data mining model in SQL Server Analysis Services and when excluding a column is helpful. |
10/31/2023 |
analysis-services |
data-mining |
conceptual |
kfollis |
kfollis |
kfollis |
[!INCLUDEappliesto-sql2019-earlier]
[!INCLUDEdm-dep-banner]
When you create a new mining model, you may not want to use all the columns that exist in the mining structure on which the model is based. For example, you might have added a customer name column for drillthrough, but don't want to use it for modeling. Or, you might decide to create multiple copies of a column with different discretizations, and use only one of the copies in each model, and ignore the rest. You could also selectively add input columns in several different models to see how the added variable affects the output column.
You do not need to create a new mining structure for each combination of columns; instead, you can simply flag a column as not being used in a particular model.
-
In the Mining Models tab of Data Mining Designer in [!INCLUDEssBIDevStudioFull], select the cell that corresponds to the column you want to exclude, under the appropriate mining model.
-
Select Ignore from the drop-down list box.