Icon

09_​Deployment_​Solution

Deployment - Solution

Solution to exercise 9 for the KNIME Analytics Platform for Data Wranglers course
- Write data on an .xls file using the Excel Writer node
- Write the data on SQLite database




Exercise 9: DeploymentIn this exercise you write preprocessed data into an Excel file and to a database. 1) Write the data on customers toan Excel file into the "data/temp"folder 2) Write the data on purchases back to the"Transactions.sqlite" database. Create or append the datainto the table called "AllTransactions". Cleaned and combined products dataConnect to DatabaseCleaned Customer DataTop: customer dataBottom: products data DB Writer SQLite Connector Excel Writer Read preprocesseddata Exercise 9: DeploymentIn this exercise you write preprocessed data into an Excel file and to a database. 1) Write the data on customers toan Excel file into the "data/temp"folder 2) Write the data on purchases back to the"Transactions.sqlite" database. Create or append the datainto the table called "AllTransactions". Cleaned and combined products dataConnect to DatabaseCleaned Customer DataTop: customer dataBottom: products data DB Writer SQLite Connector Excel Writer Read preprocesseddata

Nodes

Extensions

Links