CUBE builder

Generates a CUBE from the input data source using the chosen DIMENSION (grouping) columns. The result is a data set containing all combinations of the chosen columns with a grouping identifier.

This CUBE grouping identifier can then be used along with other chosen columns in a standard GROUP BY node to perform aggregations based on the grouping combinations


@takbb Brian Bates 19 November 2022

Options

Specify the Dimension Columns

Select the column that will form the CUBE dimensions. These are the columns by which the data will be grouped and split

Nodes

• Column Filter4 ×
• Math Formula3 ×
• RowID3 ×
• Column Rename2 ×
• Cross Joiner2 ×
• GroupBy2 ×
• Column Aggregator1 ×
• Column Filter Configuration1 ×
• Column List Loop Start1 ×
• Column Resorter1 ×
• Component Input1 ×
• Component Output1 ×
• Extract Column Header1 ×
• Extract Table Dimension1 ×
• Java Snippet1 ×
• Joiner1 ×
• Loop End (Column Append)1 ×
• Missing Value1 ×
• One Row to Many1 ×
• String Manipulation1 ×
• Table Row to Variable1 ×
• Transpose1 ×

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Data Generation
• FeatureKNIME Javasnippet
• FeatureKNIME Math Expression (JEP)
• FeatureKNIME Quick Forms

Links

• No links available