Matrix Calc using Pivoting
Matrix Calc using pivoting
Demo of matrix calculation using unpivot and pivot, which you can see is faster (even on a small table ) than the loop-calculation performed in my Matrix Calculator component
Pivot idea from @Daniel_Weikert
Nodes
- Column Filter3 ×
- Column Rename3 ×
- RowID3 ×
- Boolean Configuration2 ×
- Column Appender2 ×
- Column Filter Configuration2 ×
- Extract Table Dimension2 ×
- Integer Configuration2 ×
- Java Snippet2 ×
- Math Formula2 ×
- String Configuration2 ×
- Table Creator2 ×
- Transpose2 ×
- Unpivoting2 ×
- Add Empty Rows1 ×
- Counting Loop Start1 ×
- End IF1 ×
- Java IF (Table)1 ×
- Joiner1 ×
- Loop End (Column Append)1 ×
- Pivoting1 ×
- Rule Engine Variable1 ×
- Single Selection Configuration1 ×
- String Manipulation (Variable)1 ×
- Table Row to Variable1 ×
Extensions
- FeatureKNIME Base nodes
- FeatureKNIME Javasnippet
- FeatureKNIME Math Expression (JEP)
- FeatureKNIME Quick Forms