Icon

2020_​03_​03_​Splitting_​Multiple_​Collection_​Columns

Splitting Multiple Collection Columns
Splitting Multiple Collection ColumnsThis workflow demonstrates how to split multiple collection column using loop. Inside loop in each iteration one columnis splitted and newly created columns are renamed to have original column name using Column rename (Regex) node.For both operations flow variable currentColumnName created by Column List Loop Start node is used.Forum link: https://forum.knime.com/t/how-to-better-split-collection-columns-to-use-for-machine-learning/21494 Input dataCreate Collection columnsSplit collection vs non-collection columnsStart LoopDo the splitting Rename new columns tooriginal column nameEnd LoopAdd new columns to original data set Table Creator GroupBy Column Splitter Column ListLoop Start Split CollectionColumn Column Rename(Regex) Loop End (ColumnAppend) Column Appender Splitting Multiple Collection ColumnsThis workflow demonstrates how to split multiple collection column using loop. Inside loop in each iteration one columnis splitted and newly created columns are renamed to have original column name using Column rename (Regex) node.For both operations flow variable currentColumnName created by Column List Loop Start node is used.Forum link: https://forum.knime.com/t/how-to-better-split-collection-columns-to-use-for-machine-learning/21494 Input dataCreate Collection columnsSplit collection vs non-collection columnsStart LoopDo the splitting Rename new columns tooriginal column nameEnd LoopAdd new columns to original data set Table Creator GroupBy Column Splitter Column ListLoop Start Split CollectionColumn Column Rename(Regex) Loop End (ColumnAppend) Column Appender

Nodes

Extensions

Links