Icon

Column Merging

"Manual" method for just a handful ofcolumns being merged " Loop" method for just a larger number set ofcolumns being merged Sample DataMerge 1 and 3 into 1Merge 2 and 4 into 2List of Primaryand SecondaryColumnsto be mergedMerge primaryand SecondaryIterate thecolumn pairsAppend to output data setKeep only Primary(required because in a loop)or we get mass duplicationKeep only ID etccols from Sample Dataand join them to all cols from the loopMerge 5 and 6 into5Merge aliens and cowboys into aliens Table Creator Column Merger Column Merger Table Creator Column Merger Table Row ToVariable Loop Start Loop End (ColumnAppend) Column Filter Joiner Column Merger Column Merger "Manual" method for just a handful ofcolumns being merged " Loop" method for just a larger number set ofcolumns being merged Sample DataMerge 1 and 3 into 1Merge 2 and 4 into 2List of Primaryand SecondaryColumnsto be mergedMerge primaryand SecondaryIterate thecolumn pairsAppend to output data setKeep only Primary(required because in a loop)or we get mass duplicationKeep only ID etccols from Sample Dataand join them to all cols from the loopMerge 5 and 6 into5Merge aliens and cowboys into aliensTable Creator Column Merger Column Merger Table Creator Column Merger Table Row ToVariable Loop Start Loop End (ColumnAppend) Column Filter Joiner Column Merger Column Merger

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: brian
Created at: 2022-01-27
On NodePit since: 2022-02-06
Last update: 2024-05-01
Created with KNIME version: v4.5.0

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

Try NodePit Runner!