This node changes the order of the input columns based on the order provided at the second input table. The latter has to contain a string column with columns names as in the first input table. The columns of the first input are then sorted according to this column's (row) order. Columns not part of this sort column are sorted to the start or end or entirely dropped from the output. The sort column must not contain duplicates (node will error out). Unknown column identifiers are ignored.
Options
Popular Predecessors
- Table Creator11 %
- Sorter8 %
- Column Filter6 %
- Table Transposer5 %
- Concatenate4 %
- Pivot4 %
- Joiner4 %
- Column Resorter3 %
- GroupBy3 %
- Reference Column Filter3 %
Column Rename2 %- Row Filter2 %
- Column Appender2 %
- Excel Reader2 %
- Extract Table Spec2 %
- Duplicate Row Filter2 %
- RowID1 %
Joiner1 %- Column Expressions1 %
- Constant Value Column1 %
Excel Writer (XLS)1 %- String Manipulation1 %
- Column Renamer (Dictionary)< 1 %
- Rule Engine< 1 %
Number To String< 1 %- Column Name Extractor< 1 %
- Number to String< 1 %
- Column Auto Type Cast< 1 %
- Cross Joiner< 1 %
- Lag Column< 1 %
- Reference Row Filter< 1 %
- String to Number< 1 %
- Row to Column Names< 1 %
- Column Rename (Regex)< 1 %
- CSV Reader< 1 %
- Table Manipulator< 1 %
- Column Aggregator< 1 %
- Missing Value< 1 %
- Unpivot< 1 %
- Math Formula (Multi Column)< 1 %
- String to Date&Time< 1 %
Excel Reader (XLS)< 1 %- Column Combiner< 1 %
- String Manipulation (Multi Column)< 1 %
- Column Renamer< 1 %
- Table Validator (Reference)< 1 %
- Variable to Table Column< 1 %
File Reader< 1 %Loop End< 1 %- Double to Integer< 1 %
- Java Snippet (simple)< 1 %
- Group Loop Start< 1 %
- Reference Column Splitter< 1 %
- Send Email< 1 %
- Loop End (Column Append)< 1 %
String To Number< 1 %- Reference Row Splitter< 1 %
- Rank< 1 %
- Reference Column Resorter< 1 %
- String Replacer< 1 %
- Rule-based Row Filter< 1 %
- Parallel Chunk End< 1 %
- Math Formula< 1 %
- Date&Time to String< 1 %
- Breakpoint< 1 %
- Add Empty Rows< 1 %
- Rule-based Row Splitter< 1 %
- File Reader< 1 %
- Loop End< 1 %
- RDKit Fingerprint< 1 %
- JSON to Table< 1 %
- Extract Table Dimension< 1 %
Table Reader< 1 %Cell Replacer< 1 %- Column Comparator< 1 %
- Nominal Value Row Filter< 1 %
XLS Reader< 1 %- Remove Empty Rows< 1 %
- Missing Value Column Filter< 1 %
Counting Loop Start< 1 %- Create Table Structure< 1 %
- Statistics< 1 %
- Modify Time< 1 %
Recursive Loop End (2 ports)< 1 %- Column Splitter< 1 %
- Cell Splitter< 1 %
- Column Merger< 1 %
- DB Reader< 1 %
- Counter Generation< 1 %
- Table Editor (JavaScript)< 1 %
- JSON Path< 1 %
- Date&Time Difference< 1 %
- Date&Time-based Row Filter< 1 %
- Table Reader< 1 %
- Top k Row Filter< 1 %
- IF Switch< 1 %
- Recursive Loop End< 1 %
- Workflow Service Input< 1 %
- DB Data Spec Extractor< 1 %
- Strings to Binary Objects< 1 %
Database Connection Table Reader< 1 %- Generate 2D Coordinates< 1 %
Variable to Table Row< 1 %Excel Reader (XLS)< 1 %- Split Collection Column< 1 %
Table Row to Variable< 1 %- Java Snippet< 1 %
Variable Loop End< 1 %- Data Generator< 1 %
Excel Sheet Appender (XLS)< 1 %Python Script (1⇒1)< 1 %IF Switch (Flow Variable Value)< 1 %- Create Well Position< 1 %
Table Row to Variable< 1 %Concatenate (Optional in)< 1 %- String Matcher< 1 %
- Table Row to Variable< 1 %
- Python Script (legacy)< 1 %
CSV Reader< 1 %CSV Writer< 1 %Recursive Loop End< 1 %- Row Splitter< 1 %
- Normalizer (Apply)< 1 %
- Round Double< 1 %
Excel Reader (XLS)< 1 %- RDKit Optimize Geometry< 1 %
- Category to Number< 1 %
- Nominal Value Row Splitter< 1 %
- Value Counter< 1 %
- Cache< 1 %
- Google Sheets Reader< 1 %
- XPath< 1 %
- Variable to Table Row< 1 %
- Missing Value (Apply)< 1 %
- String Manipulation (Variable)< 1 %
- Box Plot (legacy)< 1 %
- Table View (JavaScript)< 1 %
Variable to Table Column< 1 %Variable to Table Row< 1 %Database Reader< 1 %Cell Splitter< 1 %Column Appender< 1 %- Domain Calculator< 1 %
- Row Sampling< 1 %
- Empty Table Switch< 1 %
- End IF< 1 %
- Java Edit Variable (simple)< 1 %
- Java Snippet Row Filter< 1 %
- Term to String< 1 %
- Date&Time Input (legacy)< 1 %
- R Snippet< 1 %
- Benchmark End (Memory Monitoring)< 1 %
- Collection to String< 1 %
Expand Well Position< 1 %- Split Columns by Header< 1 %
- Table to String< 1 %
- Create Collection Column< 1 %
Interval Loop Start< 1 %Generic Loop Start< 1 %- Random Forest Learner< 1 %
- Numeric Binner< 1 %
- Case Converter< 1 %
- Column to Grid< 1 %
- One to Many< 1 %
- Correlation Filter< 1 %
- Table Validator< 1 %
- Constant Value Column Filter< 1 %
- Partitioning< 1 %
- Shuffle< 1 %
- Ungroup< 1 %
- Color Manager< 1 %
- SDF Reader< 1 %
- Empty Table Creator< 1 %
- Association Rule Learner (Borgelt)< 1 %
Read Excel Sheet Names (XLS)< 1 %- Column Filter (legacy)< 1 %
- Moving Average< 1 %
- RDKit Canon SMILES< 1 %
- RDKit Interactive Table< 1 %
- URL Domain Extractor< 1 %
- Feature Selection Filter< 1 %
Loop End (2 ports)< 1 %- Chunk Loop Start< 1 %
- Tree Ensemble Predictor (Regression)< 1 %
- PMML Simple Regression Tree Predictor< 1 %
- Many to One< 1 %
- Rule Engine (Dictionary)< 1 %
CASE Switch Data (Start)< 1 %- Term Vector< 1 %
- Path to String< 1 %
- JSON Row Combiner< 1 %
- MongoDB Reader< 1 %
- Create Date&Time Range< 1 %
- Date&Time Shift< 1 %
Views
- This node has no views
Workflows
00_Integer_Zero_Pad_Example_WorkflowKNIME Hub- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- 01_Explainable_Artificial_Intelligence_(XAI)_SimpleKNIME Hub
- 01_Explainable_Artificial_Intelligence_(XAI)_SimpleKNIME Hub
- Show all 228 workflows
Links
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.