Icon

Merging Exclusive Values in Various Columns into a Single Column

Merging Exclusive Values in Various Columns into a Single Column
Strategy 2: Using Column Merger & Recursive Loop nodes A) Determine the number of maximum iterations required for the recursive loop B) Merging duplicated columns Output table withmerged column Strategy 1: Using Column Aggregator & Ungroup nodes Example columns Merges the rest of the columns into the main columnEnds recursive loop - final output hereStart recursive loopExtract column headerTranpose to a single columnFilters the top row for column merger nodeConverts the rest of the column headers into flow variablesObtain the number of columnsSet the number as a flow variableExtracts the number of columnsAggregates all values into a listRetrieves the value from the list in the same columnSplits the first column (the main column) from the restConverts the main column header into a flow variableMerges both flow variablesRename the main column headerDetermine the number of iterations by subtracting 1Example columns Column Merger Recursive Loop End RecursiveLoop Start ExtractColumn Header Transpose Row Filter Table Rowto Variable Extract TableDimension Table Rowto Variable Row Filter Column Aggregator Ungroup Row Splitter Table Rowto Variable Merge Variables Column Rename Math Formula(Variable) Table Creator Strategy 2: Using Column Merger & Recursive Loop nodes A) Determine the number of maximum iterations required for the recursive loop B) Merging duplicated columns Output table withmerged column Strategy 1: Using Column Aggregator & Ungroup nodes Example columns Merges the rest of the columns into the main columnEnds recursive loop - final output hereStart recursive loopExtract column headerTranpose to a single columnFilters the top row for column merger nodeConverts the rest of the column headers into flow variablesObtain the number of columnsSet the number as a flow variableExtracts the number of columnsAggregates all values into a listRetrieves the value from the list in the same columnSplits the first column (the main column) from the restConverts the main column header into a flow variableMerges both flow variablesRename the main column headerDetermine the number of iterations by subtracting 1Example columns Column Merger Recursive Loop End RecursiveLoop Start ExtractColumn Header Transpose Row Filter Table Rowto Variable Extract TableDimension Table Rowto Variable Row Filter Column Aggregator Ungroup Row Splitter Table Rowto Variable Merge Variables Column Rename Math Formula(Variable) Table Creator

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: astl3
Created at: 2021-02-14
On NodePit since: 2021-02-22
Last update: 2024-04-28
Created with KNIME version: v4.3.1
Tags: Recursive loopUngroupAggregationColumnIterationColumn MergerMergerMergeInput tableFlow variableDynamic

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

Try NodePit Runner!