Icon

Sorting comma separated list

A couple of methods for sorting a comma separated string.

String Manipulation is a "java hack", but always fun

sample dataCreate new columnsAggregate as sorted list(specify the set of columnscreated by Cell Splitterusing regex or wildcard)Ungroup the aggregationcolumnRe-group the "ungrouped"column as a concatenationgrouping by every column exceptthe "ungrouped" columnfun with String ManipulationTable Creator Cell Splitter Column Aggregator Ungroup GroupBy String Manipulation sample dataCreate new columnsAggregate as sorted list(specify the set of columnscreated by Cell Splitterusing regex or wildcard)Ungroup the aggregationcolumnRe-group the "ungrouped"column as a concatenationgrouping by every column exceptthe "ungrouped" columnfun with String ManipulationTable Creator Cell Splitter Column Aggregator Ungroup GroupBy String Manipulation

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: BATEB031
Created at: 2023-07-19
On NodePit since: 2023-07-19
Last update: 2024-05-01
Created with KNIME version: v4.7.4

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!