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.