The Wiki will be offline Monday, November 20, for upgrade between 10:00am ET and 5:00pm ET.
Hitachi Vantara Pentaho Community Wiki
Access Keys:
Skip to content (Access Key - 0)




An instance filter that generates output with a new order of the attributes. Useful if one wants to move an attribute to the end to use it as class attribute (e.g. with using "-R 2-last,1").
But it's not only possible to change the order of all the attributes, but also to leave out attributes. E.g. if you have 10 attributes, you can generate the following output order: 1,3,5,7,9,10 or 10,1-5.
You can also duplicate attributes, e.g. for further processing later on: e.g. 1,1,1,4,4,4,2,2,2 where the second and the third column of each attribute are processed differently and the first one, i.e. the original one is kept.
One can simply inverse the order of the attributes via 'last-first'.
After appyling the filter, the index of the class attribute is the last attribute.


The table below describes the options available for Reorder.

Option Description
attributeIndices Specify range of attributes to act on. This is a comma separated list of attribute indices, with "first" and "last" valid values. Specify an inclusive range with "-". E.g: "first-3,5,6-10,last".


The table below describes the capabilites of Reorder.

Capability Supported
Class Unary class, Nominal class, No class, Empty nominal class, Binary class, Date class, Numeric class, String class, Missing class values, Relational class
Attributes Relational attributes, Empty nominal attributes, Date attributes, Numeric attributes, Unary attributes, String attributes, Nominal attributes, Binary attributes, Missing values
Min # of instances 0

This documentation is maintained by the Pentaho community, and members are encouraged to create new pages in the appropriate spaces, or edit existing pages that need to be corrected or updated.

Please do not leave comments on Wiki pages asking for help. They will be deleted. Use the forums instead.

Adaptavist Theme Builder Powered by Atlassian Confluence