kn_example_sqlite_multiple_joins_40
SQLite - multiple joins with KNIME
I set up a demo how this could be done in KNIME although you could do that in consecutive steps or directly in a SQL database (as has been mentioned) but it is possible. Here I use SQLite which I like because it is a ‘real’ SQL database but you can just have it within one single file (you could switch that out for any SQL database).
The Join itself is done in the SQL Executor node. Plus: you have it in one step. The downside could be it might get a little bit confusing with all the steps, but you have it in one step (sort of :sunglasses:).
Nodes
- DB Writer3 ×
Excel Reader (XLS)3 ×- DB Query Reader (Labs)1 ×
- DB SQL Executor (Labs)1 ×
Excel Sheet Appender (XLS)1 ×- Show all 7 nodes