The Column Resorter node allows you to dynamically sort the order of the columns in a table. Although usually not necessary for analytic purposes, sorting the columns in a particular order can make understanding a table much easier for us as we scan from one column to another.
The Column Resorter can order columns in the following ways:
1) A-Z: alphabetically from A to Z
2) Z-A: reverse alphabetically from Z to A
3) Up and Down manually: By selecting one or more columns from the list, you can move them around at will, arranging the table exactly as you wish.
4) Move First and Move Last: By selecting one or more columns from the list, you can place them at the beginning (Move First) or end (Move Last) of the table.
5) Reset: Places the columns back into the order they were in prior to entering the Column Resorter node.
Note: There is a value listed as "". This placeholder controls what will happen if new columns are added into the table. It is important to note that, if new column appear, the alphabetical sorting will not be preserved. To preserve alphabetical sorting, you can use a flow variable.
Workflow
Column Resorter
Used extensions & nodes
Created with KNIME Analytics Platform version 4.7.2
- Go to item
- Go to item
Legal
By using or downloading the workflow, you agree to our terms and conditions.