03 - From Excel to KNIME - Solution

In this workflow several datasources from different systems are connected. You'll find "import tracks" for

- CSV files
- Databases (SQLite)
- Excel files

The interesting part here might be the middle track - the DB import - because here, the Row Filter manipulation happens on database side even before importing the table into KNIME which is usually improving a workflow's performance.

This workflow goes along with my weekly newsletter about data analytics called "The Data Alchemist's Transformation Scroll", click on the link below to find out more or subscribe for free.

External resources

• The Data Alchemists's Transofrmation Scroll