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 oncustomers to an Excel fileinto the "data/temp" folder 2) Write the data on purchases back to the"Transactions.sqlite" database. Create orappend the data into 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 oncustomers to an Excel fileinto the "data/temp" folder 2) Write the data on purchases back to the"Transactions.sqlite" database. Create orappend the data into 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

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: 2020-04-21
Last update: 2024-04-26
Created with KNIME version: v4.7.1
Tags: deploymentfile writerDB writerSQLiteETLeducationdatabase

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

Try NodePit Runner!