Icon

01_​Data_​Access

Data Access - Exercise
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 data coming from two customer information systems in .table and .csv formats 1.1 Read the file CustomerInfoSystem1.csv (CSV Reader node) 1.2 Read the file CustomerInfoSystem2.table (Table Reader node) 2) Access the data on online orders and product prizes stored on a database 2.1 Connect to the Transactions.sqlite database (SQLite Connector node) 2.2 Select the "TransactionsOnline" table on the database (DB Table Selector node) 2.3 Select the "ProductNrAndPrize" table on the database (DB Table Selector node) 2.4 Read the "ProductNrAndPrize" into KNIME (DB Reader) Optional3) Access the data on onsite purchases and the locations of the stores in .xlsx and .table formats 3.1 Read the file Stores.xlsx (Excel Reader (XLS) node) 3.2 Read the file TransactionsStore.table (Table Reader node) 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 data coming from two customer information systems in .table and .csv formats 1.1 Read the file CustomerInfoSystem1.csv (CSV Reader node) 1.2 Read the file CustomerInfoSystem2.table (Table Reader node) 2) Access the data on online orders and product prizes stored on a database 2.1 Connect to the Transactions.sqlite database (SQLite Connector node) 2.2 Select the "TransactionsOnline" table on the database (DB Table Selector node) 2.3 Select the "ProductNrAndPrize" table on the database (DB Table Selector node) 2.4 Read the "ProductNrAndPrize" into KNIME (DB Reader) Optional3) Access the data on onsite purchases and the locations of the stores in .xlsx and .table formats 3.1 Read the file Stores.xlsx (Excel Reader (XLS) node) 3.2 Read the file TransactionsStore.table (Table Reader node)

Nodes

  • No nodes found

Extensions

  • No modules found

Links