Icon

Column Resorter

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.

Column Resorter The Column Resorter node allows you to dynamically sort the order of the columns in atable. Although usually not necessary for analytic purposes, sorting the columns in aparticular order can make understanding a table much easier for us as we scan fromone column to another.The Column Resorter can order columns in the following ways:1) A-Z: alphabetically from A to Z2) Z-A: reverse alphabetically from Z to A3) Up and Down manually: By selecting one or more columns from the list, you canmove 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 canplace 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 theColumn Resorter node.Note: There is a value listed as "<any unknown new column>". This placeholdercontrols what will happen if new columns are added into the table. It is important tonote that, if new column appear, the alphabetical sorting will not be preserved. Topreserve alphabetical sorting, you can use a flow variable. Sort columns alphabetically from A to Z. Notice that the placeholder <any unknown newcolumn> was placed in the first location (itsalphabetic location) Manually sort the columns by using the Up and Downcontrols.Notice where we placed the placeholder value. Anynew columns will be placed at the end of the table. Night Heron Data, 2023 Input some dataSort alphabeticallyA-ZManually sortthe columns Table Creator Column Resorter Column Resorter Column Resorter The Column Resorter node allows you to dynamically sort the order of the columns in atable. Although usually not necessary for analytic purposes, sorting the columns in aparticular order can make understanding a table much easier for us as we scan fromone column to another.The Column Resorter can order columns in the following ways:1) A-Z: alphabetically from A to Z2) Z-A: reverse alphabetically from Z to A3) Up and Down manually: By selecting one or more columns from the list, you canmove 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 canplace 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 theColumn Resorter node.Note: There is a value listed as "<any unknown new column>". This placeholdercontrols what will happen if new columns are added into the table. It is important tonote that, if new column appear, the alphabetical sorting will not be preserved. Topreserve alphabetical sorting, you can use a flow variable. Sort columns alphabetically from A to Z. Notice that the placeholder <any unknown newcolumn> was placed in the first location (itsalphabetic location) Manually sort the columns by using the Up and Downcontrols.Notice where we placed the placeholder value. Anynew columns will be placed at the end of the table. Night Heron Data, 2023 Input some dataSort alphabeticallyA-ZManually sortthe columns Table Creator Column Resorter Column Resorter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: johnemery
Created at: 2023-05-19
On NodePit since: 2023-05-21
Last update: 2024-05-03
Created with KNIME version: v4.7.2
Tags: column resorternode bitesnight heron data

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!