This node rotates the selected columns from the input table to rows and duplicates at the same time the remaining input columns by appending them to each corresponding output row. Example:
Input: Value1 Value2 Value3 Extra1 Extra2 Extra3 Output: Value1 Extra1 Extra2 Extra3 Value2 Extra1 Extra2 Extra3 Value3 Extra1 Extra2 Extra3
Options
Value columns
Retained columns
Performance
Popular Successors
Column Rename9 %- Column Filter7 %
Row Filter (deprecated)7 %- Joiner6 %
- GroupBy5 %
- String Manipulation4 %
- Column Renamer3 %
- Pivot3 %
- Rule Engine3 %
- Excel Writer3 %
- Rule-based Row Filter3 %
- Cell Splitter2 %
- Column Expressions2 %
- Concatenate2 %
- Missing Value2 %
- Column Resorter2 %
- Table Manipulator1 %
- Duplicate Row Filter1 %
- Constant Value Column< 1 %
Row Splitter (deprecated)< 1 %- String to Date&Time< 1 %
- Math Formula< 1 %
- Sorter< 1 %
- String to Number< 1 %
- Heatmap< 1 %
- Loop End< 1 %
- Rule-based Row Splitter< 1 %
- CSV Writer< 1 %
XLS Writer< 1 %- Column Auto Type Cast< 1 %
- Table Transposer< 1 %
- Reference Row Filter< 1 %
- Rank< 1 %
Table Column to Variable< 1 %- Column Renamer (Dictionary)< 1 %
- String Replacer< 1 %
- Cross Joiner< 1 %
- Unpivot< 1 %
- Java Snippet< 1 %
Variable to Table Column< 1 %- Column Splitter< 1 %
- Column Combiner< 1 %
- RowID< 1 %
- Group Loop Start< 1 %
Cell Replacer< 1 %- Pie/Donut Chart (JavaScript)< 1 %
- Column Appender< 1 %
- String Splitter (Regex)< 1 %
Python Script (1⇒1)< 1 %- Nominal Value Row Filter< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
- Variable to Table Column< 1 %
- Column List Loop Start< 1 %
- Ungroup< 1 %
- Column Comparator< 1 %
- Number to String< 1 %
- Linear Correlation< 1 %
- Nominal Value Row Splitter< 1 %
- Table View (JavaScript)< 1 %
- Case Converter< 1 %
- Java Snippet (simple)< 1 %
- Chunk Loop Start< 1 %
- Scatter Plot (Plotly)< 1 %
- Table Creator< 1 %
Recursive Loop Start (2 ports)< 1 %- Add Empty Rows< 1 %
- Column Rename (Regex)< 1 %
- Interactive Table (legacy)< 1 %
Excel Writer (XLS)< 1 %- Replacer< 1 %
Table Writer< 1 %- Column Name Extractor< 1 %
- JSON to Table< 1 %
- Data to Report (BIRT)< 1 %
Extract Date&Time Fields< 1 %- Date&Time Part Extractor< 1 %
- Table Row to Variable Loop Start< 1 %
- Column Aggregator< 1 %
- Lag Column< 1 %
- Denormalizer< 1 %
- Independent groups t-test< 1 %
- Java Snippet Row Filter< 1 %
- Table to JSON< 1 %
- Python View (legacy)< 1 %
Linear Correlation< 1 %- Similarity Search< 1 %
- R Snippet< 1 %
- String to Date/Time (legacy)< 1 %
- Create Collection Column< 1 %
- Loop End (Column Append)< 1 %
Column Appender< 1 %- Reference Row Splitter< 1 %
Joiner< 1 %- Normalizer< 1 %
- Reference Column Resorter< 1 %
- Rank Correlation< 1 %
- Table to PDF (legacy)< 1 %
- Send to Tableau Server< 1 %
- String Matcher< 1 %
- Google Sheets Updater< 1 %
- Date Extractor< 1 %
- 1D Kernel Density Plot< 1 %
CSV Writer< 1 %- Table Writer< 1 %
- One to Many< 1 %
- Missing Value Column Filter< 1 %
- Partitioning< 1 %
- Column Filter (PMML)< 1 %
- Missing Value (Apply)< 1 %
- Value Counter< 1 %
- CASE Switch Start< 1 %
- Empty Table Switch< 1 %
- Table to Spark< 1 %
- Bar Chart (JavaScript)< 1 %
- Math Formula (Multi Column)< 1 %
- Bag Of Words Creator< 1 %
- Heatmap (JavaScript)< 1 %
- String to JSON< 1 %
- JSON Path< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Moving Aggregator< 1 %
- RDKit Descriptor Calculation< 1 %
- Range Filter< 1 %
- Dose Response (R)< 1 %
- String to URI< 1 %
Table Column to Variable< 1 %- Table Row to Variable< 1 %
- Recursive Loop End< 1 %
- Linear Regression Learner< 1 %
- Auto-Binner< 1 %
- Binner (Dictionary)< 1 %
- Cell Splitter By Position< 1 %
- Category to Number< 1 %
- Column Merger< 1 %
- Row Splitter (Labs)< 1 %
- Top k Row Filter< 1 %
- Value Lookup< 1 %
- Ruleset Editor< 1 %
- Rule Engine (Dictionary)< 1 %
- Data Explorer< 1 %
- Statistics< 1 %
- Conditional Box Plot (legacy)< 1 %
- Line Plot< 1 %
- DB Insert< 1 %
- DB Loader< 1 %
- DB Writer< 1 %
- One Row to Many< 1 %
- Google Sheets Writer< 1 %
- Value Selection Configuration< 1 %
- Column Filter (legacy)< 1 %
- Column Selection (legacy)< 1 %
- Nominal Row Filter Widget< 1 %
- POST Request< 1 %
- Date&Time Difference< 1 %
- Date&Time-based Row Filter< 1 %
- Modify Time< 1 %
- Moving Average< 1 %
- Time to String (legacy)< 1 %
- Molecule to CDK< 1 %
- Regex Extractor< 1 %
- URL Encode< 1 %
- R Snippet< 1 %
- R Plot< 1 %
- Split Collection Column< 1 %
- Table Column to Variable< 1 %
Loop End< 1 %Counting Loop Start< 1 %- Column to Grid< 1 %
- Domain Calculator< 1 %
- Double to Integer< 1 %
- Reference Column Filter< 1 %
- Constant Value Column Filter< 1 %
- Filter Apply< 1 %
- Row Filter (Labs)< 1 %
- Number to String (PMML)< 1 %
- Number Rounder< 1 %
- Row Aggregator< 1 %
- Row to Column Names< 1 %
- Row Sampling< 1 %
- String Manipulation (Multi Column)< 1 %
- String Replacer (Dictionary)< 1 %
- Table Difference Finder< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- One-way ANOVA< 1 %
- Paired t-test< 1 %
- CASE Switch End< 1 %
- Extract Table Spec< 1 %
- Interactive Histogram (legacy)< 1 %
- Interactive Pie chart (legacy)< 1 %
- Color Manager< 1 %
- ROC Curve (legacy)< 1 %
- Bar Chart< 1 %
- Box Plot< 1 %
- Density Plot< 1 %
- Pie Chart< 1 %
- Scatter Plot< 1 %
- Table View< 1 %
- Parquet Writer< 1 %
- Parallel Chunk End< 1 %
- DB Table Creator< 1 %
- Counter Generation< 1 %
- Error Bars Plot (Plotly)< 1 %
- Line Plot (Plotly)< 1 %
- Violin Plot (Plotly)< 1 %
- HeatMap (JFreeChart)< 1 %
XLS Sheet Appender< 1 %Excel Writer (XLS)< 1 %- Send to Power BI< 1 %
Tableau Writer (Hyper)< 1 %- Tableau Writer< 1 %
- Path to String< 1 %
- Multiple Selections (legacy)< 1 %
- Line Plot (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Columns to JSON< 1 %
- Auto Crop< 1 %
- Object Inserter< 1 %
- Python Script (legacy)< 1 %
- R View (Table)< 1 %
- Date&Time to String< 1 %
- Duration to Number< 1 %
- Date&Time Shift< 1 %
- String to XML< 1 %
Regex Extractor< 1 %- Create File Name (legacy)< 1 %
Database Connector< 1 %Variable Condition Loop End< 1 %- Regression Predictor< 1 %
- Numeric Binner< 1 %
- Create Bit Vector< 1 %
Cell Splitter< 1 %- Equal Size Sampling< 1 %
- Normalizer (PMML)< 1 %
- Target Shuffling< 1 %
- Shape Manager< 1 %
- Distance Matrix Calculate< 1 %
- Line Chart (JFreeChart)< 1 %
- Strings to Document< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- TIBCO Spotfire File Writer< 1 %
- Speedy SMILES Heavy Atom Count (HAC)< 1 %
- Combine Columns by Header< 1 %
- Breakpoint< 1 %
Table Column to Variable< 1 %- Table to Image< 1 %
Recursive Loop End< 1 %- Filter Apply Row Splitter< 1 %
- String to Number (PMML)< 1 %
- Numeric Row Splitter< 1 %
- Shuffle< 1 %
String Replace (Dictionary)< 1 %- End IF< 1 %
- Crosstab< 1 %
- DB Merge< 1 %
DB Table Creator< 1 %- 3D Scatter Plot (Plotly)< 1 %
Table to HTML< 1 %- Bar Chart (JFreeChart)< 1 %
Excel Reader (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %- Java Snippet Row Splitter< 1 %
- Value Selection (legacy)< 1 %
- Table Editor (JavaScript)< 1 %
- Date&Time Widget< 1 %
- JSON Row Combiner< 1 %
- Column to XML< 1 %
- Remove Empty Rows< 1 %
- RDKit Interactive Table< 1 %
- HTTP Retriever< 1 %
- CIR< 1 %
- XLS Control Table Generator< 1 %
- Reaction Builder< 1 %
- Expand Barcode< 1 %
- Plate Heatmap Viewer< 1 %
- Upload (legacy)< 1 %
- URI to String< 1 %
- Active Branch Inverter< 1 %
Variable to Table Column< 1 %Table Row To Variable Loop Start< 1 %- ARFF Writer< 1 %
Generic Loop Start< 1 %- Hierarchical Clustering< 1 %
- k-Means< 1 %
- PCA< 1 %
- Perl Scripting< 1 %
String To Number< 1 %- Table Validator< 1 %
- Edit Nominal Domain< 1 %
Column Filter< 1 %- Reference Column Splitter< 1 %
- Key-Collection HiLite Translator< 1 %
- Subset Matcher< 1 %
Missing Value< 1 %String To Number (PMML)< 1 %- Wilcoxon-Mann-Whitney Test< 1 %
CASE Switch Data (Start)< 1 %- Timer Info< 1 %
- Scatter Plot (legacy)< 1 %
- Molecule Type Cast< 1 %
- SDF Writer< 1 %
- Microsoft SQL Server Connector< 1 %
- Random Number Assigner< 1 %
- Pie Chart (JFreeChart)< 1 %
- Scatter Plot (JFreeChart)< 1 %
- Ruby Script< 1 %
Excel Sheet Appender (XLS)< 1 %Send to Power BI< 1 %- Dictionary Tagger< 1 %
- Nominal Row Filter Configuration< 1 %
- Tag Cloud (JavaScript)< 1 %
- Container Output (Table)< 1 %
- Image Normalizer< 1 %
- Adaptive Median< 1 %
MongoDB Writer< 1 %Python View< 1 %- R Learner< 1 %
- Table to R< 1 %
- Date&Time to legacy Date&Time< 1 %
- RDKit From Molecule< 1 %
- RDKit Find Murcko Scaffolds< 1 %
- Column Packer< 1 %
- Canonical SMILES< 1 %
- InChi< 1 %
- Substructure Matcher< 1 %
- Table Row To Variable Run-for-time Loop Start< 1 %
- Inject Column Properties< 1 %
- Append Plate Well IDs< 1 %
- Create Well Position< 1 %
- Number Formatter< 1 %
- Normalize Plates (POC)< 1 %
- Normalize Plates (Z-Score)< 1 %
- MarvinView< 1 %
- ZXing Encoder< 1 %
- 2D/3D Scatterplot< 1 %
- URL to Audio< 1 %
- Binary Objects to Strings< 1 %
Table Row to Variable< 1 %Table Row to Variable< 1 %Image Writer (Table Column)< 1 %CSV Reader< 1 %Database Reader< 1 %Database Writer< 1 %- Table Reader< 1 %
- Java Edit Variable< 1 %
Loop End (2 ports)< 1 %Recursive Loop Start< 1 %Variable Loop End< 1 %- Hierarchical Clustering (DistMatrix)< 1 %
- Decision Tree Predictor< 1 %
- Polynomial Regression Learner< 1 %
- Numeric Scorer< 1 %
- Association Rule Learner< 1 %
Concatenate (Optional in)< 1 %- Bootstrap Sampling< 1 %
- Category to Number (Apply)< 1 %
- Number to Category (Apply)< 1 %
Number To String< 1 %- Many to One< 1 %
- Table Validator (Reference)< 1 %
- Edit Numeric Domain< 1 %
Double To Int< 1 %- Normalizer (Apply)< 1 %
- Many to One (PMML)< 1 %
- Set Operator< 1 %
- String Manipulation (Variable)< 1 %
- Renderer to Image< 1 %
- Ruleset Predictor< 1 %
- Rule Engine Variable (Dictionary)< 1 %
Linear Discriminant Analysis< 1 %- Numeric Outliers< 1 %
- Kruskal-Wallis Test< 1 %
- Single sample t-test< 1 %
- Linear Discriminant Analysis< 1 %
CASE Switch Data (End)< 1 %- IF Switch< 1 %
- Cache< 1 %
- Extract Table Dimension< 1 %
Merge Variables< 1 %- Send Email< 1 %
- Histogram (legacy)< 1 %
- Pie chart (legacy)< 1 %
- Box Plot (legacy)< 1 %
- Line Plot (legacy)< 1 %
Color Appender< 1 %- Visualization Property Extractor< 1 %
- Parallel Chunk End (multi port)< 1 %
- Parallel Chunk Start< 1 %
Microsoft SQL Server Connector< 1 %- DB Column Rename< 1 %
- Gaussian Distributed Assigner< 1 %
- Numeric Distances< 1 %
- String Distances< 1 %
K Nearest Neighbor (Distance Function)< 1 %- 2D Density Plot (Plotly)< 1 %
- Bubble Chart (Plotly)< 1 %
- Conditional Box Plot (JavaScript)< 1 %
- Continuous Error Plot (Plotly)< 1 %
- Histogram (JavaScript)< 1 %
- Stacked Area Chart (Plotly)< 1 %
- Sunburst Chart (JavaScript)< 1 %
- Variable Expressions< 1 %
- OpenBabel< 1 %
- Association Rule Learner (Borgelt)< 1 %
- Item Set Finder (Borgelt)< 1 %
- Math Formula (Variable)< 1 %
- Bubble Chart (JFreeChart)< 1 %
- Table Indexer< 1 %
- OSM Map View< 1 %
XLS Reader< 1 %Excel Reader (XLS)< 1 %- Excel Reader< 1 %
TIBCO File Writer< 1 %- Radar Plot Appender< 1 %
Tableau Writer (TDE)< 1 %- Diacritic Remover< 1 %
- Punctuation Erasure< 1 %
- Dictionary Tagger (Multi Column)< 1 %
- OpenNLP NE Tagger< 1 %
Document vector< 1 %- Term to String< 1 %
- Document Viewer< 1 %
- Delete Files/Folders (Table)< 1 %
Column Filter Configuration< 1 %- Value Filter (legacy)< 1 %
- Lift Chart (JavaScript)< 1 %
- Interactive Value Filter Widget< 1 %
- Value Selection Widget< 1 %
- JSON Path (Dictionary)< 1 %
- Container Output (JSON)< 1 %
- Colorspace Converter< 1 %
- Don't Save Start< 1 %
- Feature Inserter< 1 %
Python Script (1⇒1)< 1 %Python Script (2⇒2)< 1 %- Python Learner (legacy)< 1 %
Python Script (1⇒2)< 1 %- Add Table to R< 1 %
- GET Request< 1 %
- Webpage Retriever< 1 %
- Table Difference Checker< 1 %
- Legacy Date&Time to Date&Time< 1 %
- String to Duration< 1 %
- Modify Date< 1 %
- Window Loop Start< 1 %
- Date/Time Shift (legacy)< 1 %
- Time Difference (legacy)< 1 %
- Date Field Extractor (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
- Preset Date/Time (legacy)< 1 %
- XML Column Combiner< 1 %
- XPath< 1 %
- Table to HTML String< 1 %
- Row Splitter (col+)< 1 %
- Result< 1 %
- Sum Formula< 1 %
- RDKit From IUPAC< 1 %
- RDKit MCS< 1 %
- RDKit Molecule Fragmenter< 1 %
- Text Classifier Learner< 1 %
Location Extractor< 1 %- MapQuest Geocoder< 1 %
- Geo Distances< 1 %
- URL Domain Extractor< 1 %
Views
- This node has no views
Workflows
[03.CX] Extracting and Transforming Viber Broadcast Data from InfobipKNIME Hub- [04.CX] Capturing Messenger LiveChat Data in Real-Time with ManyChat and Google SheetsKNIME Hub
- 00 Data GenerationKNIME Hub
- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- Show all 1191 workflows
Links
- transpose particular columns to rowsby ipazin on 2018-08-14forum.knime.com/p/46467
- How to replace multiple values in different columnsby armingrudd on 2019-10-07forum.knime.com/p/71840
- Transform matrix into single row valuesby armingrudd on 2019-10-14forum.knime.com/p/72264
- Pivoting with multiple columnsby HansS on 2019-12-10forum.knime.com/p/76641
- Use of Pivoting or Unpivotingby tommy on 2021-04-07forum.knime.com/p/120259
- Show all 18 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.