Icon

2019_​07_​23_​GroupBy_​Data_​Preparation

GroupBy Data PreparationThis workflow uses Rule Engine and Missing Value node in order to prepare data (assign unique group identifier) for GroupBy node.Forum link: https://forum.knime.com/t/multiline-values-to-single-line/16960 Input dataAssign unique identifierPopulate other members from group with same identifierDrop "{" and "}" rowsGroup itLeave only nodes unique valuesJoin back Table Creator Rule Engine Missing Value Rule-basedRow Filter GroupBy Rule-basedRow Filter Joiner GroupBy Data PreparationThis workflow uses Rule Engine and Missing Value node in order to prepare data (assign unique group identifier) for GroupBy node.Forum link: https://forum.knime.com/t/multiline-values-to-single-line/16960 Input dataAssign unique identifierPopulate other members from group with same identifierDrop "{" and "}" rowsGroup itLeave only nodes unique valuesJoin back Table Creator Rule Engine Missing Value Rule-basedRow Filter GroupBy Rule-basedRow Filter Joiner

Nodes

Extensions

Links