Export (0) Print
Expand All

Specify Column Content and Data Type (Data Mining Wizard)

Use the Specify Column Content and Data Type page to specify the usage and data type for each column that you selected on the previous page of the wizard. If you want to ignore the column, click Back to return to the page Specify the Training Data, and clear all checkboxes.

The usage of a column indicates how the data will be used in the model. A column can be used as a key to identify a series, as an input value to use in analysis, or as the value that you want to predict. Columns can be used for both prediction and input.

The data type specifies additional detail about the type of data that is contained in the column, and how the data will be used during training. Some content types require a specific data type, and vice versa. You might also need to specify a particular data type depending on the algorithm that you use when you create a mining model. For information about content types and data types in mining models and structures, see Content Types (Data Mining).

For More Information: Mining Structures (Analysis Services - Data Mining), Mining Model Columns, Data Mining Wizard (Analysis Services - Data Mining), Create a Relational Mining Structure

Mining model structure

Displays the columns from the views and nested tables that you selected on the previous page of the wizard.

Columns

Lists the columns.

Content type

Specify the content type for the column. If you specified that the column is a key on the previous page of the wizard, the following values are available:

Option

Description

Key

Specify that the column contains a unique identifier for the case series.

Key Sequence

Specify that the column contains a sequence identifier.

Key Time

Specify that the column contains a date or other unique continuous number that is used to identify a date or time series.

If you selected the column as a non-key column, the following values are available, depending on the data type:

Option

Description

Continuous

Specify that the column contains continuous numeric values.

Discretized

Specify that the column contains numeric values that either have been discretized, or can be treated as discrete values.

Discrete

Specify that the column contains text or other nonnumeric values.

Data type

Specify the data type for the column.

The following values are available:

  • Boolean

  • Date

  • Double

  • Long

  • Text

Detect

Analyze a sample of data in all numeric columns. Replaces specified Content Type values with a recommended content type.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft