Icon

20230704 Pikairos Compare Column Headers From 2 Tables

Compare the column headers in two different tables using Extract Column Header and Joiner nodes

Excel1Excel2Extract Namesas ColumnExtract Namesas ColumnJoin onColumn HeaderColumnFull Outer JoinSplit OutputHeaders inboth ExcelsHeaders in Excel 1but not Excel 2Headers in Excel 2but not Excel 1AppendBoth Listsof ColumnHeadersIf Column Namesare the Same = TRUEIf Not = FALSEReorderTable 2 ColumnsBased onList of ColumnsFrom Table 1Excel Reader Excel Reader ExtractColumn Header ExtractColumn Header Joiner Table View (Labs) Table View (Labs) Table View (Labs) Column Appender Rule Engine ReferenceColumn Resorter Excel1Excel2Extract Namesas ColumnExtract Namesas ColumnJoin onColumn HeaderColumnFull Outer JoinSplit OutputHeaders inboth ExcelsHeaders in Excel 1but not Excel 2Headers in Excel 2but not Excel 1AppendBoth Listsof ColumnHeadersIf Column Namesare the Same = TRUEIf Not = FALSEReorderTable 2 ColumnsBased onList of ColumnsFrom Table 1Excel Reader Excel Reader ExtractColumn Header ExtractColumn Header Joiner Table View (Labs) Table View (Labs) Table View (Labs) Column Appender Rule Engine ReferenceColumn Resorter

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: LAMBERT
Created at: 2023-07-04
On NodePit since: 2023-07-04
Last update: 2024-04-27
Created with KNIME version: v4.7.4
Tags: Extract Column HeaderJoiner

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

Try NodePit Runner!