Skip to main content

Select Attributes (In Database)

Synopsis

Filters the list of columns of the current data set.

Description

This operator only keeps certain columns according to its parameters.

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.