Icon

kn_​example_​db_​sqlite_​right_​joiner_​loop

Construct a Right Join with SQLite

I built a workflow that does that also to play around with SQLite and to see what it could do.
I have two databases that both have two tables named “table_01” and “table_02”. They have the same structure Col1 … but two cells are different than the others. Task is now to isolate these cells and leave the ones out that are identical

Construct a Right Join with SQLitehttps://forum.knime.com/t/joiner-node-in-loop/11343/5?u=mlauber71I built a workflow that does that also to play around with SQLite and to see what it could do.I have two databases that both have two tables named “table_01” and “table_02”. They have the same structure Col1 … but twocells are different than the others. Task is now to isolate these cells and leave the ones out that are identical this is just to demonstrate the ouput... loop remaining excelsheetsconstruct temporary new_idbuild the joinsyntaxtable_not_identicalcreate database_01.sqliteselect all Tablescreate database_02.sqlitetransfer single table to other DBDROP TABLE IF EXISTS_temp_tabletransfer to temporary table_temp_tabletable_not_identicalthe rows that are not identicalNode 473database_results.xlsxTable Row ToVariable Loop Start Variable Loop End create database_01 create database_02 RowID constructjoin syntax Java EditVariable (simple) SQLite Connector DB Query Reader DB Table Selector SQLite Connector DB Query Reader DB SQL Executor DB Writer DB SQL Executor DB Query Reader Rule-basedRow Filter Excel SheetAppender (XLS) Construct a Right Join with SQLitehttps://forum.knime.com/t/joiner-node-in-loop/11343/5?u=mlauber71I built a workflow that does that also to play around with SQLite and to see what it could do.I have two databases that both have two tables named “table_01” and “table_02”. They have the same structure Col1 … but twocells are different than the others. Task is now to isolate these cells and leave the ones out that are identical this is just to demonstrate the ouput... loop remaining excelsheetsconstruct temporary new_idbuild the joinsyntaxtable_not_identicalcreate database_01.sqliteselect all Tablescreate database_02.sqlitetransfer single table to other DBDROP TABLE IF EXISTS_temp_tabletransfer to temporary table_temp_tabletable_not_identicalthe rows that are not identicalNode 473database_results.xlsxTable Row ToVariable Loop Start Variable Loop End create database_01 create database_02 RowID constructjoin syntax Java EditVariable (simple) SQLite Connector DB Query Reader DB Table Selector SQLite Connector DB Query Reader DB SQL Executor DB Writer DB SQL Executor DB Query Reader Rule-basedRow Filter Excel SheetAppender (XLS)

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: m_lauber
Created at: 2018-06-29
On NodePit since: 2020-09-19
Last update: 2024-04-28
Created with KNIME version: v4.2.1
Tags: sqlsqlitejoinrightloop

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

Try NodePit Runner!