Icon

01_​Data_​Access

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

Nodes

Extensions

Links