Skip to main content

Declare Missing Value (In Database)

Synopsis​

Declares a missing numeric or nominal value on a selected subset.

Description​

The given value will be replaced with NULL throughout the specified subset, so it will be treated as a missing value by subsequent operators.

Input​

example set input​

Output​

example set output​

Parameters​

Attribute filter type​

The condition specifies which attributes are selected or affected by this operator.

Attribute​

The attribute which should be chosen.

Attributes​

The attribute which should be chosen.

Regular expression​

A regular expression for the names of the attributes which should be kept.

Use except expression​

If enabled, an exception to the specified regular expression might be specified. Attributes of matching this will be filtered out, although matching the first expression.

Except regular expression​

A regular expression for the names of the attributes which should be filtered out although matching the above regular expression.

Value type​

The value type of the attributes.

Use value type exception​

If enabled, an exception to the specified value type might be specified. Attributes of this type will be filtered out, although matching the first specified type.

Except value type​

Except this value type.

Block type​

The block type of the attributes.

Use block type exception​

If enabled, an exception to the specified block type might be specified.

Except block type​

Except this block type.

Numeric condition​

Parameter string for the condition, e.g. >= 5

Invert selection​

Indicates if only attributes should be accepted which would normally filtered.

Mode​

Select the value type of the missing value

Numeric value​

This parameter defines the missing numerical value

Nominal value​

This parameter defines the missing nominal value

Expression value​

This parameter defines the expression which if true equals the missing value