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 DatabaseTop: customer dataBottom: products dataCleaned Customer Data DB Writer SQLite Connector Read preprocesseddata Excel Writer 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 DatabaseTop: customer dataBottom: products dataCleaned Customer Data DB Writer SQLite Connector Read preprocesseddata Excel Writer

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: 2021-11-22
Last update: 2024-11-18
Created with KNIME version: v4.3.0
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!