Icon

Populate one table from another

Join and replace or merge a column in one table from another

Sample DataTable ASample DataTable Bwhich has a totallyemptyColumn_ID columnjoin tables, return all cols from Table Bexcept Column_IDand returnjust Column_ID from table Areturn Matching rows and Left Unmatched rowsSample DataTable ASample DataTable Bcolumn_ID might bepartially populatedjoin tables, return all cols from Table Band just Column_ID from table Areturn Matching rows and Left Unmatched rowspopulate Column_IDwith Column_ID (right)determing which column has precedenceif already populatedin this case we will keep the Table B valueif it is present.To always overwrite Table B values, switch the Primary andSecondary columns in the configremovenow redundantColumn_ID (right)Extract Data Tablefrom Delimited Text Extract Data Tablefrom Delimited Text Joiner Extract Data Tablefrom Delimited Text Extract Data Tablefrom Delimited Text Joiner Column Merger Column Filter Sample DataTable ASample DataTable Bwhich has a totallyemptyColumn_ID columnjoin tables, return all cols from Table Bexcept Column_IDand returnjust Column_ID from table Areturn Matching rows and Left Unmatched rowsSample DataTable ASample DataTable Bcolumn_ID might bepartially populatedjoin tables, return all cols from Table Band just Column_ID from table Areturn Matching rows and Left Unmatched rowspopulate Column_IDwith Column_ID (right)determing which column has precedenceif already populatedin this case we will keep the Table B valueif it is present.To always overwrite Table B values, switch the Primary andSecondary columns in the configremovenow redundantColumn_ID (right)Extract Data Tablefrom Delimited Text Extract Data Tablefrom Delimited Text Joiner Extract Data Tablefrom Delimited Text Extract Data Tablefrom Delimited Text Joiner Column Merger Column Filter

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: bbate
Created at: 2023-07-24
On NodePit since: 2023-07-25
Last update: 2024-04-27
Created with KNIME version: v4.7.4

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

Try NodePit Runner!