Icon

2020_​02_​19_​Flow_​Variable_​control_​of_​Columns_​in_​GroupBy

Flow Variable control of columns in GroupBy
Flow Variable control of columns in GroupByThis workflow demonstrates how to use flow variable of Collection type to specify grouping columns in GroupBy node. Different setof grouping columns are defined in Table Creator node after which Chunk Loop Start node is utilized with 1 row per chunk. Theninside loop flow variable of Collection type is created and use in GroupBy node. With Loop End node results are concatenated. Forum link: https://forum.knime.com/t/how-to-apply-different-column-combinations-1-column-in-group-by-node-by-flow-variables/21120 Grouping ColumnsInput dataOne row per chunkCreate Collection column from all columnsDo groupingCollect resultsCreate flow variable of Colection type Table Creator Table Creator Chunk Loop Start Create CollectionColumn GroupBy Loop End Table Rowto Variable Flow Variable control of columns in GroupByThis workflow demonstrates how to use flow variable of Collection type to specify grouping columns in GroupBy node. Different setof grouping columns are defined in Table Creator node after which Chunk Loop Start node is utilized with 1 row per chunk. Theninside loop flow variable of Collection type is created and use in GroupBy node. With Loop End node results are concatenated. Forum link: https://forum.knime.com/t/how-to-apply-different-column-combinations-1-column-in-group-by-node-by-flow-variables/21120 Grouping ColumnsInput dataOne row per chunkCreate Collection column from all columnsDo groupingCollect resultsCreate flow variable of Colection type Table Creator Table Creator Chunk Loop Start Create CollectionColumn GroupBy Loop End Table Rowto Variable

Nodes

Extensions

Links