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