Icon

Merging Columns from Full Outer Joiner node

Merging Columns from Full Outer Joiner node
1) Determine the number of maximum iterations required for the recursive loop 2) Merging duplicated columns Two input tables Output table withmerged columns Full outer join, with all columns includedExtract column headerFilter duplicated columns(by default containing " (#1)")Tranpose to a single columnMerges the duplicated columnsEnds recursive loop - final output hereStart recursive loopExtract column headerTranpose to a single columnFilter duplicated columns(by default containing " (#1)")Create a column of deduplicated column headersFilters the top row for column merger nodeConverts the top row into flow variablesObtain the number of duplicated columnsSet the number as a flow variableTable 1Table 2 Joiner ExtractColumn Header Row Filter Transpose Column Merger Recursive Loop End RecursiveLoop Start ExtractColumn Header Transpose Row Filter String Manipulation Row Filter Table Rowto Variable Extract TableDimension Table Rowto Variable Table Creator Table Creator 1) Determine the number of maximum iterations required for the recursive loop 2) Merging duplicated columns Two input tables Output table withmerged columns Full outer join, with all columns includedExtract column headerFilter duplicated columns(by default containing " (#1)")Tranpose to a single columnMerges the duplicated columnsEnds recursive loop - final output hereStart recursive loopExtract column headerTranpose to a single columnFilter duplicated columns(by default containing " (#1)")Create a column of deduplicated column headersFilters the top row for column merger nodeConverts the top row into flow variablesObtain the number of duplicated columnsSet the number as a flow variableTable 1Table 2 Joiner ExtractColumn Header Row Filter Transpose Column Merger Recursive Loop End RecursiveLoop Start ExtractColumn Header Transpose Row Filter String Manipulation Row Filter Table Rowto Variable Extract TableDimension Table Rowto Variable Table Creator 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-01-24
On NodePit since: 2021-01-25
Last update: 2024-04-27
Created with KNIME version: v4.3.0
Tags: Full Outer JoinColumn MergerRecursive LoopFlow variableDynamicInput tableJoinerJoinMerge column

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

Try NodePit Runner!