Icon

01_​Data_​Access_​Solution

Data Access - Solution

Solution to exercise 1 for the KNIME Analytics Platform for Data Wranglers course
- Import data from different file formats (csv, table, xls)
- Import data from SQLite database







Exercise 1: Data AccessIn this exercise you access data available in different file types. The data that you read in this exercise is stored in the"data" folder. 1) Access the following files: 1.1 CustomerInfoSystem1.csv (CSV Reader node) 1.2 CustomerInfoSystem2.table (Table Reader node) 2) Access the data on a database via the following steps: 2.1 Connect to the Transactions.sqlite database (SQLite Connector node) 2.2 Select the "TransactionsOnline" table (DB Table Selector node) 2.3 Select the "ProductNrAndPrize" table (DB Table Selector node) 2.4 Read the "ProductNrAndPrize" table into KNIME (DB Reader) Optional3) Access the following files: 3.1 Stores.xlsx (Excel Reader node) 3.2 TransactionsStore.table (Table Reader node) Connect to DatabaseProduct ID and PriceTransactions OnlineCustomer InformationSystem 1Store InformationCustomer InformationSystem 2Transactions Store SQLite Connector DB Table Selector DB Table Selector DB Reader CSV Reader Excel Reader Table Reader Table Reader Exercise 1: Data AccessIn this exercise you access data available in different file types. The data that you read in this exercise is stored in the"data" folder. 1) Access the following files: 1.1 CustomerInfoSystem1.csv (CSV Reader node) 1.2 CustomerInfoSystem2.table (Table Reader node) 2) Access the data on a database via the following steps: 2.1 Connect to the Transactions.sqlite database (SQLite Connector node) 2.2 Select the "TransactionsOnline" table (DB Table Selector node) 2.3 Select the "ProductNrAndPrize" table (DB Table Selector node) 2.4 Read the "ProductNrAndPrize" table into KNIME (DB Reader) Optional3) Access the following files: 3.1 Stores.xlsx (Excel Reader node) 3.2 TransactionsStore.table (Table Reader node) Connect to DatabaseProduct ID and PriceTransactions OnlineCustomer InformationSystem 1Store InformationCustomer InformationSystem 2Transactions Store SQLite Connector DB Table Selector DB Table Selector DB Reader CSV Reader Excel Reader Table Reader Table Reader

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: Maarit Laukkanen
Created at: 2019-10-18
On NodePit since: 2023-04-05
Last update: 2024-05-01
Created with KNIME version: v4.7.2
Tags: ETLreadcsvtableexcelSQLitedata accesseducation

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

Try NodePit Runner!