Icon

03 - From Excel to KNIME - Data Integration

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.

Excel Import Track Database (SQLite) Import Track CSV Import Track What is this all about?In this workflow several datasources from different systems are connected. You'll find "import tracks" for CSV files, Databases(SQLite), Excel filesThe interesting part here might be the middle track - the DB import - because here, the Row Filter manipulation happens ondatabase 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 TransformationScroll", click on the link below to find out more or subscribe for free.Connect to HR SystemsSQLite DBSelect theBuyer Locationstable fromthe DBselect only locations with Country = DEread the final table into KNIMEimporttransactional line items(PVO)import suppliersfrom legacysystemadd buyersto PVO datasetadd suppliers(legacy) to PVOdatasetSQLite Connector DB Table Selector DB Row Filter DB Reader Excel Reader CSV Reader Joiner Joiner Excel Import Track Database (SQLite) Import Track CSV Import Track What is this all about?In this workflow several datasources from different systems are connected. You'll find "import tracks" for CSV files, Databases(SQLite), Excel filesThe interesting part here might be the middle track - the DB import - because here, the Row Filter manipulation happens ondatabase 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 TransformationScroll", click on the link below to find out more or subscribe for free.Connect to HR SystemsSQLite DBSelect theBuyer Locationstable fromthe DBselect only locations with Country = DEread the final table into KNIMEimporttransactional line items(PVO)import suppliersfrom legacysystemadd buyersto PVO datasetadd suppliers(legacy) to PVOdatasetSQLite Connector DB Table Selector DB Row Filter DB Reader Excel Reader CSV Reader Joiner Joiner

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: philk
Created at: 2023-09-20
On NodePit since: 2023-09-20
Last update: 2024-11-18
Created with KNIME version: v4.7.2
Tags: excelcsvnosqlsqlite

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

Try NodePit Runner!