Performs a pivoting on the given input table using a selected number of columns for grouping and pivoting. The group columns will result into unique rows, whereby the pivot values turned into columns for each set of column combinations together with each aggregation method. In addition, the node returns the total aggregation (a) based on only the group columns and (b) based on only the pivoted columns resulting in a single row; optionally, with the total aggregation without pivoting.
To change the aggregation method of more than one column select all columns to change, open the context menu with a right mouse click and select the aggregation method to use.
A detailed description of the available aggregation methods can be found on the 'Description' tab in the node dialog.
Options
Group settings
Pivot settings
Manual Aggregation
Advanced settings
Output Ports
- Pivot table.
- A table containing the totals for each defined group. That is, the aggregation for each group ignoring the pivoting groups. This table can be joined with the Pivot table; the RowIDs of both tables represent the same groups). The table will contain as many rows as there are different groups in the data and as many columns as there are selected aggregations. The table is identical to the output of a GroupBy node, in which the group and aggregation columns are chosen accordingly.
- A single row table containing the aggregated values of the Pivot table. The table structure is identical to the Pivot table (possibly enriched by overall totals if the "Append overall totals" is selected. This table is usually concatenated with table that results from joining the Pivot table with the Group table.
Popular Predecessors
- GroupBy11 %
- Row Filter9 %
- Joiner5 %
- Rule Engine4 %
- Rule-based Row Filter4 %
- Math Formula4 %
- Concatenate3 %
- Column Filter3 %
- String Manipulation3 %
- Excel Reader2 %
Column Rename2 %- Column Expressions2 %
- Sorter2 %
- Extract Date&Time Fields2 %
- Duplicate Row Filter2 %
- Missing Value2 %
- Nominal Value Row Filter2 %
- Unpivot2 %
- String to Number2 %
- CSV Reader2 %
- Column Resorter2 %
- Row Splitter1 %
- Loop End1 %
- Constant Value Column1 %
- Pivot1 %
- Rule-based Row Splitter1 %
- Date&Time-based Row Filter< 1 %
- DB Reader< 1 %
- DB Query Reader< 1 %
- Cell Splitter< 1 %
- Reference Row Filter< 1 %
- String to Date&Time< 1 %
- Table Manipulator< 1 %
- File Reader< 1 %
- Column Combiner< 1 %
- Value Counter< 1 %
- Number to String< 1 %
- Column Renamer< 1 %
- Rank< 1 %
- Table Creator< 1 %
- Group Loop Start< 1 %
Excel Reader (XLS)< 1 %Joiner< 1 %- Nominal Value Row Splitter< 1 %
XLS Reader< 1 %- Date&Time to String< 1 %
- Numeric Binner< 1 %
- Round Double< 1 %
- RowID< 1 %
- Column Aggregator< 1 %
- Math Formula (Multi Column)< 1 %
Cell Replacer< 1 %- Ungroup< 1 %
- Auto-Binner< 1 %
- Color Manager< 1 %
- String Manipulation (Multi Column)< 1 %
- String Replacer< 1 %
- Column Appender< 1 %
- Row Filter (Labs)< 1 %
- Table Reader< 1 %
- Tags to String< 1 %
Loop End< 1 %- Date&Time Difference< 1 %
- Column Splitter< 1 %
- Java Snippet< 1 %
- IF Switch< 1 %
- Value Lookup< 1 %
- Cross Joiner< 1 %
Excel Writer (XLS)< 1 %- Table Transposer< 1 %
- Column Merger< 1 %
- Modify Date< 1 %
- Missing Value Column Filter< 1 %
- Reference Row Splitter< 1 %
- Value Filter (legacy)< 1 %
- Column Auto Type Cast< 1 %
- Date Field Extractor (legacy)< 1 %
Extract Date&Time Fields< 1 %- Column List Loop Start< 1 %
- Modify Time< 1 %
- String Replacer (Dictionary)< 1 %
- Column Name Extractor< 1 %
Excel Sheet Appender (XLS)< 1 %- XPath< 1 %
- Domain Calculator< 1 %
- Excel Writer< 1 %
- Linear Regression Learner< 1 %
Excel Reader (XLS)< 1 %- CASE Switch Start< 1 %
- Chunk Loop Start< 1 %
- Row Sampling< 1 %
- End IF< 1 %
- Empty Table Switch< 1 %
- Data Explorer< 1 %
- TF< 1 %
- JSON to Table< 1 %
Table Row to Variable< 1 %- Normalizer< 1 %
- Crosstab< 1 %
- Counter Generation< 1 %
Table Row To Variable Loop Start< 1 %- Term to String< 1 %
Table Column to Variable< 1 %Scorer< 1 %- Cell Splitter By Position< 1 %
- Column Rename (Regex)< 1 %
- Regex Split< 1 %
- Statistics< 1 %
- Line Plot (JavaScript)< 1 %
- Python Script (legacy)< 1 %
File Reader< 1 %- Numeric Row Splitter< 1 %
- Interactive Value Filter Widget< 1 %
- Table Row to Variable< 1 %
- Row Aggregator< 1 %
Variable to Table Column< 1 %- Column Renamer (Dictionary)< 1 %
- Denormalizer< 1 %
- Molecule Type Cast< 1 %
- R Snippet< 1 %
- Moving Aggregator< 1 %
- Recursive Loop End< 1 %
- Tika Language Detector< 1 %
Database Reader< 1 %- Category to Number< 1 %
- JSON Path< 1 %
- Plate Heatmap Viewer< 1 %
- Fuzzy c-Means< 1 %
- k-Means< 1 %
Random Forest Predictor< 1 %CASE Switch Data (End)< 1 %- Table Row to Variable Loop Start< 1 %
- Entropy Scorer< 1 %
- Case Converter< 1 %
- Filter Apply< 1 %
- SDF Reader< 1 %
Document Data Extractor< 1 %- Parameter Optimization Loop End< 1 %
- Moving Average< 1 %
- Row Splitter (Labs)< 1 %
- Google Sheets Reader< 1 %
- Parquet Reader< 1 %
- String to Path< 1 %
- R to Table< 1 %
- Image Writer (Port)< 1 %
- Split Collection Column< 1 %
- Date&Time Shift< 1 %
- Nominal Row Filter Configuration< 1 %
- Read Excel Sheet Names< 1 %
- Salesforce Simple Query< 1 %
- Row to Column Names< 1 %
CSV Writer< 1 %- Polynomial Regression Learner< 1 %
- Cache< 1 %
Color Appender< 1 %- Spark to Table< 1 %
- Multiple Selections (legacy)< 1 %
- Network Analyzer< 1 %
- String to Date/Time (legacy)< 1 %
- DB Writer< 1 %
- Column Filter Widget< 1 %
- Column Selection Widget< 1 %
- Linear Correlation< 1 %
- Table Difference Finder< 1 %
- Merge Variables< 1 %
Database Looping< 1 %- Binner (Dictionary)< 1 %
- Double to Integer< 1 %
- Document Data Extractor< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Top k Row Filter< 1 %
- Rule Engine Variable< 1 %
Parquet Reader< 1 %- Java Edit Variable (simple)< 1 %
- Variable to Table Column< 1 %
- Number Formatter< 1 %
- Read Images< 1 %
- Cluster Assigner< 1 %
- Lag Column< 1 %
CASE Switch Data (Start)< 1 %- Constant Value Column Filter< 1 %
- String to Number (PMML)< 1 %
- Reference Column Resorter< 1 %
- Parallel Chunk Start< 1 %
- Bag Of Words Creator< 1 %
- Nominal Row Filter Widget< 1 %
- ImageJ Macro< 1 %
- Create Date&Time Range< 1 %
- MolConverter< 1 %
- Loop End (Column Append)< 1 %
Recursive Loop End (2 ports)< 1 %- Logistic Regression Learner< 1 %
- Random Forest Predictor (Regression)< 1 %
- Add Empty Rows< 1 %
Concatenate (Optional in)< 1 %- Many to One< 1 %
- CAIM Binner< 1 %
- Partitioning< 1 %
- String Manipulation (Variable)< 1 %
- Rule Engine (Dictionary)< 1 %
- Box Plot (legacy)< 1 %
- Parallel Chunk End< 1 %
- Java Snippet (simple)< 1 %
- Single Selection (legacy)< 1 %
- Date&Time to legacy Date&Time< 1 %
- Filter Apply Row Splitter< 1 %
Number To String (PMML)< 1 %- Extract Table Spec< 1 %
- Parameterized DB Query Reader< 1 %
- Similarity Search< 1 %
- Table Column to Variable< 1 %
- File Reader (Complex Format)< 1 %
- Number to String (PMML)< 1 %
- CASE Switch End< 1 %
- Table to JSON< 1 %
- Python Source (legacy)< 1 %
- RDKit From Molecule< 1 %
- Normalize Plates (POC)< 1 %
- Create Collection Column< 1 %
Variable to Table Row< 1 %CSV Reader< 1 %Regression Predictor< 1 %- Column Comparator< 1 %
Column Appender< 1 %- Correlation Filter< 1 %
- Edit Nominal Domain< 1 %
- Reference Column Filter< 1 %
- Missing Value (Apply)< 1 %
String Replace (Dictionary)< 1 %- Extract Table Dimension< 1 %
Merge Variables< 1 %- Term Co-Occurrence Counter< 1 %
- Value Selection (legacy)< 1 %
- Table View (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- Date/Time Shift (legacy)< 1 %
- Regression Predictor< 1 %
- Equal Size Sampling< 1 %
- Numeric Outliers< 1 %
- Shape Manager< 1 %
- Column Selection Configuration< 1 %
- Date&Time Input (legacy)< 1 %
Extract Outer/InnerHTML< 1 %- Run Garbage Collector< 1 %
- Variable to Table Row< 1 %
- Variable Creator< 1 %
- RDKit Descriptor Calculation< 1 %
- Date&Time Configuration< 1 %
- Path to String< 1 %
- Anonymization< 1 %
- Regex Extractor< 1 %
Expand Well Position< 1 %- Join Layout< 1 %
Database Connection Table Reader< 1 %Database Writer< 1 %- Fixed Width File Reader< 1 %
Table Reader< 1 %Loop End (2 ports)< 1 %Variable Condition Loop End< 1 %Recursive Loop Start< 1 %PCA< 1 %- Column to Grid< 1 %
- One to Many< 1 %
Double To Int< 1 %- Subset Matcher< 1 %
String To Number (PMML)< 1 %- Ruleset Predictor< 1 %
- One-way ANOVA< 1 %
- Conditional Box Plot (legacy)< 1 %
- Random Number Assigner< 1 %
Excel Reader (XLS)< 1 %- Column Filter (legacy)< 1 %
- Column Selection (legacy)< 1 %
- Scatter Plot (JavaScript)< 1 %
Python Script (1⇒1)< 1 %- UNIX Timestamp to Date&Time< 1 %
- Numeric Scorer< 1 %
- PCA< 1 %
- Simple Regression Tree Predictor< 1 %
- Reference Column Splitter< 1 %
- Normalizer (Apply)< 1 %
- Denormalizer (PMML)< 1 %
- Variable Expressions< 1 %
- Math Formula (Variable)< 1 %
Read Excel Sheet Names (XLS)< 1 %- Interactive Range Slider Filter Widget< 1 %
Regex Extractor< 1 %- Canonical SMILES< 1 %
- CSV Writer< 1 %
- Variable Loop End< 1 %
- Create Table Structure< 1 %
- List Files/Folders< 1 %
- Tag Cloud (JavaScript)< 1 %
- Multiple Selection Widget< 1 %
- Recursive Loop Start< 1 %
- DB Looping< 1 %
- NGram Creator< 1 %
- Table Cropper< 1 %
- Table Splitter< 1 %
- R Snippet< 1 %
- GPCRDB Protein similarity< 1 %
- ARFF Reader< 1 %
List Files< 1 %Variable Loop End< 1 %- Association Rule Learner< 1 %
Cell Splitter< 1 %String To Number< 1 %- Rule-based Row Filter (Dictionary)< 1 %
- Paired t-test< 1 %
- ROC Curve (legacy)< 1 %
- SDF Stripper< 1 %
- Java Snippet Row Splitter< 1 %
Document vector< 1 %Python Script (1⇒1)< 1 %Variable to Table Row< 1 %- Random Forest Learner< 1 %
- Table Validator< 1 %
- H2O to Table< 1 %
- Stop Word Filter< 1 %
- Multiport Loop End< 1 %
- RDKit SMILES Headers< 1 %
- Inject Variables (Data)< 1 %
Parameterized Database Query< 1 %- Java Edit Variable< 1 %
Recursive Loop End< 1 %- Create Bit Vector< 1 %
Number To String< 1 %- Column Filter (PMML)< 1 %
Rank Correlation< 1 %- Independent groups t-test< 1 %
- Random Label Assigner< 1 %
- Image Converter< 1 %
- Edge Table< 1 %
- R Source (Table)< 1 %
- Time Difference (legacy)< 1 %
- RDKit Canon SMILES< 1 %
- TIBCO Spotfire File Reader< 1 %
- Fingerprints Expander< 1 %
- XLS Named Range Reader< 1 %
Generic Loop Start< 1 %- DBSCAN< 1 %
- SVM Predictor< 1 %
- Random Forest Predictor< 1 %
- Number to Category (Apply)< 1 %
- Numeric Binner (PMML)< 1 %
- Violin Plot (Plotly)< 1 %
- Category to Class< 1 %
- Tag Filter< 1 %
- Image Normalizer< 1 %
- ARIMA Parameter Extractor< 1 %
- Single sample t-test< 1 %
- KCS SAP Generic Node(Deprecated)< 1 %
- Term Document Entropy< 1 %
- Value Filter Definition (legacy)< 1 %
- Text Output Widget (legacy)< 1 %
- Refresh Button Widget< 1 %
- Google Address Geocoder< 1 %
- Outlier Removal< 1 %
- Wait...< 1 %
Database Table Connector< 1 %Line Reader< 1 %- X-Aggregator< 1 %
- PNN Predictor< 1 %
- Decision Tree Predictor< 1 %
- MultiLayerPerceptron Predictor< 1 %
Numeric Scorer< 1 %Tree Ensemble Predictor< 1 %- Auto-Binner (Apply)< 1 %
- DF< 1 %
Bag of Words Creator< 1 %- Image Properties< 1 %
- SPARQL Query< 1 %
- Extract Time Window (legacy)< 1 %
- XLS Control Table Generator< 1 %
- Create Well Position< 1 %
- Expand Barcode< 1 %
- Normalize Plates (B-Score)< 1 %
- Try (Variable Ports)< 1 %
Variable to Table Column< 1 %- SOTA Predictor< 1 %
Random Forest Predictor< 1 %- Bootstrap Sampling< 1 %
Linear Correlation< 1 %- Edit Numeric Domain< 1 %
- Renderer to Image< 1 %
- Timer Info< 1 %
- Size Manager< 1 %
- Index Query< 1 %
- Google Sheets Writer< 1 %
- Value Selection Configuration< 1 %
- JSON Path (Dictionary)< 1 %
- Columns to JSON< 1 %
- Image Cropper< 1 %
- Time Generator (legacy)< 1 %
- Row Splitter (col+)< 1 %
- Neo4j Reader< 1 %
IF Switch (Flow Variable Value)< 1 %- Collection Size< 1 %
Simple File Reader< 1 %- X-Partitioner< 1 %
Excel Sheet Appender (XLS)< 1 %- Webpage Retriever< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %Loop End (3 ports)< 1 %- Coordinate Row Filter< 1 %
- Try (Data Ports)< 1 %
- Hierarchical Clustering< 1 %
PCA Compute< 1 %- SMOTE< 1 %
Gradient Boosted Trees Predictor< 1 %- Tree Ensemble Predictor< 1 %
- Distance Matrix Pair Extractor< 1 %
- Extract Missing Value Cause< 1 %
- HiLite Row Splitter< 1 %
CASE Switch Variable (Start)< 1 %- Data Generator< 1 %
- k-Medoids< 1 %
K Nearest Neighbor (Distance Function)< 1 %- Parallel Coordinates Plot (JavaScript)< 1 %
Excel Writer (XLS)< 1 %- Java Snippet Row Filter< 1 %
- IDF< 1 %
- Topic Extractor (Parallel LDA)< 1 %
- Snowball Stemmer< 1 %
- Document Vector< 1 %
- String Input (legacy)< 1 %
- Don't Save End< 1 %
- Edge Adjacency Matrix< 1 %
Python Script (2⇒2)< 1 %- Python Edit Variable (legacy)< 1 %
- Triple File Reader< 1 %
- Time Field Extractor (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- Time to String (legacy)< 1 %
- Twitter Search< 1 %
- RDKit Generate Coords< 1 %
Column Distance< 1 %Read Sequence< 1 %- FileToTable< 1 %
- Hartree-to-kcal/mol Converter< 1 %
- Extract Properties< 1 %
Loop End (Upto 6 ports)< 1 %- Range Filter< 1 %
- Normalize Plates (NPI)< 1 %
- Envision Reader< 1 %
- Free-Wilson Matched Pairs< 1 %
- Strings to Binary Objects< 1 %
- URI Port to Variable< 1 %
- URI to String< 1 %
- URL to File Path< 1 %
- Breakpoint< 1 %
- Catch Errors (Data Ports)< 1 %
- Active Branch Inverter< 1 %
Table Row to Variable< 1 %Database SQL Executor< 1 %Line Reader< 1 %Counting Loop Start< 1 %Interval Loop Start< 1 %Naive Bayes Predictor< 1 %- Naive Bayes Predictor< 1 %
- Fuzzy Rule Predictor< 1 %
- Hierarchical Cluster Assigner (local)< 1 %
K Nearest Neighbor< 1 %PCA Apply< 1 %- Logistic Regression Predictor< 1 %
Gradient Boosted Trees Predictor< 1 %- Expand Bit Vector< 1 %
- Table Validator (Reference)< 1 %
- Interactive HiLite Collector< 1 %
- Low Variance Filter< 1 %
- Many to One (PMML)< 1 %
- One to Many (PMML)< 1 %
- Shuffle< 1 %
- Ruleset Editor< 1 %
- Numeric Median Test< 1 %
- HiLite Table (legacy)< 1 %
- Lift Chart (legacy)< 1 %
- PMML Transformation Apply< 1 %
- Parallel Chunk End (multi port)< 1 %
- Empty Table Creator< 1 %
- One Row to Many< 1 %
- Random Number Assigner (Apache)< 1 %
- TimeDelay Loop End< 1 %
- Mahalanobis Distance< 1 %
- Distance Matrix Calculate< 1 %
- Scatter Plot (Plotly)< 1 %
- Boosting Learner Loop Start< 1 %
- OpenBabel< 1 %
- Generic Web Service Client< 1 %
- H2O Numeric Scorer< 1 %
- LIBSVMPredictor< 1 %
- SAS7BDAT Reader< 1 %
- Java IF (Table)< 1 %
- Frequency Filter< 1 %
- String Matcher< 1 %
- PDF Parser< 1 %
Meta Info Extractor< 1 %- String to Term< 1 %
- Unique Term Extractor< 1 %
Column Filter Configuration< 1 %- String Configuration< 1 %
Column Selection Configuration< 1 %- CSS Editor< 1 %
- Image Output (legacy)< 1 %
- Range Slider Filter Definition (legacy)< 1 %
- File Upload (legacy)< 1 %
- List Box Input (legacy)< 1 %
- Heatmap (JavaScript)< 1 %
- Boolean Widget< 1 %
- String Widget< 1 %
- Container Input (Table)< 1 %
- Container Output (Table)< 1 %
JSON Reader< 1 %- Rowset Filter< 1 %
Python Script (2⇒1)< 1 %Column Selection QuickForm (legacy)< 1 %- Duration to Number< 1 %
- Window Loop Start< 1 %
- Preset Date/Time (legacy)< 1 %
- XGBoost Predictor< 1 %
XML Reader< 1 %- XSLT< 1 %
- RDKit Molecule Extractor< 1 %
- RDKit R-Group Decomposition< 1 %
- RDKit Substructure Counter< 1 %
- Text Classifier Predictor< 1 %
Date Extractor< 1 %- Latitude/Longitude to Coordinate< 1 %
- String Similarity< 1 %
- URL Domain Extractor< 1 %
- Web Searcher< 1 %
- List Folders< 1 %
- Load text-based files< 1 %
- Extract Column Properties< 1 %
- Binning Apply< 1 %
- Normalize Plates (Z-Score)< 1 %
- Python Snippet< 1 %
- Similarity Calculator< 1 %
- ARIMA Predictor< 1 %
- Extract Variables (Data)< 1 %
Table Column to Variable< 1 %- Extract System Properties< 1 %
- Line Reader< 1 %
- Variable Condition Loop End< 1 %
- Fuzzy Rule Learner< 1 %
- Scorer< 1 %
- PMML Gradient Boosted Trees Predictor< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Numeric Outliers (Apply)< 1 %
- Kruskal-Wallis Test< 1 %
- ORC Reader< 1 %
Parquet Reader< 1 %- DB Connection Closer< 1 %
- DB Update< 1 %
- TimeDelay Loop Start< 1 %
- H2O Random Forest Learner< 1 %
- Chi-Square Keyword Extractor< 1 %
- Keygraph Keyword Extractor< 1 %
- Case Converter< 1 %
- Replacer< 1 %
- Weka Cluster Assigner (3.7)< 1 %
- Column Filter Configuration< 1 %
- Double Configuration< 1 %
- Integer Configuration< 1 %
- Multiple Selection Configuration< 1 %
- String to JSON< 1 %
- Feature Calculator (BETA)< 1 %
- POST Request< 1 %
- String to XML< 1 %
- RDKit To Molecule< 1 %
- RDKit Salt Stripper< 1 %
- Date Extractor< 1 %
Views
- This node has no views
Workflows
_01_PMR_AnalysisKNIME Hub- 0. Lubes_Sales_Pred-ModelNodePit Space
- 0. Lubes_Sales_Pred-ModelNodePit Space
- 00 Main MenuKNIME Hub
- 00 Main MenuKNIME Hub
- Show all 2518 workflows
Links
- Please Help: How to Add Columns toby danielesser on 2020-06-06forum.knime.com/p/93580
- How to replace multiple values in different columnsby armingrudd on 2019-10-07forum.knime.com/p/71840
- how to merge tables, one with single instance and the other with multiple instances for a unique IDby armingrudd on 2019-09-26forum.knime.com/p/71082
- Crear Tabla - Nodeby knimediger on 2021-08-20forum.knime.com/p/132475
- Loop and Join while filtering different row informationby armingrudd on 2019-12-12forum.knime.com/p/76809
- Show all 19 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.