Data access

Introduction to KNIME

Emilio Silvestri

Data Scientist, KNIME

Data access

  Acess data from different sources

Introduction to KNIME

Data access

 

  Excel Reader node

  Output table

Introduction to KNIME

File types

  • .csv
  • .txt
  • .xlsx
  • .json
  • .xml
  • .table
  • .png
  • ...

Reader nodes

Introduction to KNIME

File path

Maze empty

Introduction to KNIME

Absolute file path

Maze from start

Introduction to KNIME

Relative file path

Maze from middle

Introduction to KNIME

Connected file systems

  Cloud services logos

Introduction to KNIME

Connected file systems

  Connect to Google Drive

Introduction to KNIME

Multiple files

 

  Folders

Multiple Excel Reader nodes

Introduction to KNIME

Reading folders

 

  Folders

Excel Reader node reading multiple files

Introduction to KNIME

Accessing Databases

 

 

4 nodes to query databases

Introduction to KNIME

Let's practice!

Introduction to KNIME

Preparing Video For Download...