Icon

01. Importing Data SH

Importing Data - Solution

Solution to the exercise 1 for KNIME User Training
- Import data from three different file formats (table, csv, xls)
- Import data from SQLite database

Activity: Importing DataImport data from: - Sentiment Analysis.table - Sentiment Rating.csv - Product Data2.xls (hint: Drag and drop files from the KNIME Explorer panel)Optional: Read web_activity table from the database WebActivity.sqlite WebActivity.sqliteWebActivity Sentiment Rating+Sentiment DescriptionRead Product Data2.xlsSentiment Evaluation from KNIMESQLite Connector DB Reader DB Table Selector CSV Reader Excel Reader Table Reader Activity: Importing DataImport data from: - Sentiment Analysis.table - Sentiment Rating.csv - Product Data2.xls (hint: Drag and drop files from the KNIME Explorer panel)Optional: Read web_activity table from the database WebActivity.sqlite WebActivity.sqliteWebActivity Sentiment Rating+Sentiment DescriptionRead Product Data2.xlsSentiment Evaluation from KNIMESQLite Connector DB Reader DB Table Selector CSV Reader Excel Reader Table Reader

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
On NodePit since: 2023-06-17
Last update: 2024-11-23
Created with KNIME version: v4.6.1
Tags: ETLdata accessimportcsvxlstableimportreaddatabaseSQLiteeducation

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

Try NodePit Runner!