Skip to main content

Reorder Attributes (In Database)

Synopsis

This operator can define the order of the attributes.

Description

This operator can define the order of the attributes. It is also possible to define an attribute order for a subset of attributes (regular expressions can be used) and SELECT only them and remove the unmatched attributes. You can also to sort the unmatched attributes and append or prepend them to the specified attribute list.

Input

example set input

Output

example set output

Parameters

Order mode

Ordering method that should be applied.

Attribute ordering

Rules to order attributes.

Use regular expressions

If checked attribute orders will be evaluated as regular expressions.

Handle unmatched

Defines the behavior for unmatched attributes.

Unmatched direction

Sort direction for unmatched attribute names.

Sort direction

Sort direction for attribute names.