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 Successors
- Excel Writer6 %
- Column Resorter4 %
- Column Filter3 %
- Joiner3 %
- Concatenate3 %
Row Filter (deprecated)3 %- Loop End2 %
- Sorter2 %
- Table Difference Checker2 %
- CSV Writer2 %
- Column Renamer (Dictionary)1 %
- Missing Value1 %
Column Appender1 %- Column Name Extractor1 %
- Duplicate Row Filter1 %
- Rule Engine1 %
- GroupBy1 %
- Math Formula (Multi Column)1 %
- Constant Value Column1 %
- Reference Column Resorter1 %
- Heatmap (JavaScript)1 %
- Column Rename (Regex)< 1 %
- Column Expressions< 1 %
- Reference Column Splitter< 1 %
- Number Rounder< 1 %
- Math Formula< 1 %
- Pivot< 1 %
- Table Transposer< 1 %
Excel Writer (XLS)< 1 %- XLS Border Formatter< 1 %
- One to Many< 1 %
- Reference Column Filter< 1 %
- Reference Row Filter< 1 %
- Write To Excel Template< 1 %
Loop End< 1 %- Column List Loop Start< 1 %
- Recursive Loop End< 1 %
- Column Aggregator< 1 %
- Column Appender< 1 %
- Table Manipulator< 1 %
- Denormalizer< 1 %
- Partitioning< 1 %
- String Replacer< 1 %
- Unpivot< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
- String to Path< 1 %
- XLS Control Table Generator< 1 %
- Write To Excel Template (deprecated)< 1 %
CSV Writer< 1 %- Table Writer< 1 %
- Table Creator< 1 %
- Java Snippet< 1 %
- Loop End (Column Append)< 1 %
- Group Loop Start< 1 %
Cell Replacer< 1 %- Cell Splitter< 1 %
- Column Auto Type Cast< 1 %
- Column Combiner< 1 %
- String to Number< 1 %
- Cross Joiner< 1 %
- Table Validator (Reference)< 1 %
- Missing Value Column Filter< 1 %
Row Splitter (deprecated)< 1 %Column Rename< 1 %- RowID< 1 %
- Column Splitter< 1 %
- String Manipulation< 1 %
- String Manipulation (Multi Column)< 1 %
- Table Difference Finder< 1 %
- Rule-based Row Filter< 1 %
- Rule-based Row Splitter< 1 %
- CASE Switch End< 1 %
- Empty Table Switch< 1 %
- End IF< 1 %
- Extract Table Spec< 1 %
DB Loader< 1 %- DB Loader< 1 %
- DB Writer< 1 %
- Counter Generation< 1 %
- HeatMap (JFreeChart)< 1 %
Microsoft Authenticator (Deprecated)< 1 %- Table View (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- String to Date&Time< 1 %
- Moving Aggregator< 1 %
Database Update< 1 %- Number to String< 1 %
- Nominal Value Row Filter< 1 %
- Rule Engine Variable< 1 %
- Numeric Outliers< 1 %
- Statistics< 1 %
CASE Switch Data (End)< 1 %- Line Plot (Plotly)< 1 %
Recursive Loop Start< 1 %Concatenate (Optional in)< 1 %- Create Bit Vector< 1 %
- Column Comparator< 1 %
- Lag Column< 1 %
- Line Plot (legacy)< 1 %
Hive Loader (legacy)< 1 %- DB Delete (Table)< 1 %
- PMML Predictor< 1 %
XLS Writer< 1 %- Table to JSON< 1 %
- Python View (legacy)< 1 %
- Create Collection Column< 1 %
- Catch Errors (Data Ports)< 1 %
- Inject Variables (Data)< 1 %
- Feature Selection Loop Start (1:1)< 1 %
- Chunk Loop Start< 1 %
Recursive Loop End (2 ports)< 1 %Number To String< 1 %- Column Merger< 1 %
- Correlation Filter< 1 %
- Ungroup< 1 %
CASE Switch Data (Start)< 1 %- Extract Table Dimension< 1 %
- Merge Variables< 1 %
- Interactive Table (legacy)< 1 %
- DB Table Creator< 1 %
- Keras Network Executor< 1 %
- Keras Network Learner< 1 %
Excel Sheet Appender (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %- Line Plot (JavaScript)< 1 %
- Columns to JSON< 1 %
Python Script (2⇒1)< 1 %- Date&Time to String< 1 %
- Legacy Date&Time to Date&Time< 1 %
- String to XML< 1 %
- XLS Font Formatter< 1 %
- XLS Control Table from Cell Range< 1 %
- Reaction Splitter< 1 %
- TIBCO Spotfire File Writer< 1 %
IF Switch (Flow Variable Value)< 1 %- Collection to String< 1 %
- Inject Column Properties< 1 %
- 2D/3D Scatterplot< 1 %
- Split Collection Column< 1 %
- URL to File Path< 1 %
- Breakpoint< 1 %
- Catch Errors (Var Ports)< 1 %
Variable to Table Column< 1 %Table Row to Variable< 1 %Table Row To Variable Loop Start< 1 %CSV Reader< 1 %Database Delete< 1 %Database Writer< 1 %Database Table Creator< 1 %File Reader< 1 %Table Writer< 1 %Loop End (2 ports)< 1 %Variable Condition Loop End< 1 %Generic Loop Start< 1 %- Hierarchical Clustering (DistMatrix)< 1 %
- Logistic Regression Predictor< 1 %
Scorer< 1 %- Add Empty Rows< 1 %
- Auto-Binner< 1 %
Cell Splitter< 1 %String To Number< 1 %Linear Correlation< 1 %- Domain Calculator< 1 %
- Double to Integer< 1 %
- Extract Missing Value Cause< 1 %
- Constant Value Column Filter< 1 %
- Row Splitter (Labs)< 1 %
- Reference Row Splitter< 1 %
Joiner< 1 %- Subset Matcher< 1 %
- Normalizer (Apply)< 1 %
- Normalizer< 1 %
- Missing Value (Apply)< 1 %
- Rank< 1 %
- Row Sampling< 1 %
- Set Operator< 1 %
- String Manipulation (Variable)< 1 %
- Target Shuffling< 1 %
- Value Counter< 1 %
- IF Switch< 1 %
- Conditional Box Plot (legacy)< 1 %
- Histogram (legacy)< 1 %
- Pie chart (legacy)< 1 %
- Color Manager< 1 %
- ROC Curve (legacy)< 1 %
- SDF Writer< 1 %
- DB Insert< 1 %
- DB Update< 1 %
DB Table Creator< 1 %- Bar Chart (JavaScript)< 1 %
- Stacked Area Chart (JavaScript)< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
- Line Chart (JFreeChart)< 1 %
Excel Writer (XLS)< 1 %- Java Snippet (simple)< 1 %
- Radar Plot Appender< 1 %
- Strings to Document< 1 %
- Path to String< 1 %
- String to Path (Variable)< 1 %
- Google Sheets Appender< 1 %
- Google Sheets Updater< 1 %
- Date&Time Configuration< 1 %
- Column Selection (legacy)< 1 %
- Image Viewer< 1 %
- Python Predictor (legacy)< 1 %
Python Script (1⇒1)< 1 %- Python Script (legacy)< 1 %
- R Predictor< 1 %
- Table to R< 1 %
- Data to Report (BIRT)< 1 %
- POST Request< 1 %
- Date&Time Difference< 1 %
- Date&Time-based Row Filter< 1 %
- Modify Time Zone< 1 %
- Time Generator (legacy)< 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 286 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.