Icon

4_​Examples

This directory contains 6 workflows.

Icon01_​Database_​Simple_​IO_​Example 

This workflow demonstrates using DB Query Reader and DB Writer nodes in a simple KNIME worflow. It uses the file-based "sqlite" database (the entire […]

Icon02_​Database_​Advanced_​Example 

This workflow shows a KNIME workflow with a number of database nodes that directly work inside a database. It uses the file-based "sqlite" database (the […]

Icon03_​Read_​and_​Write_​PNG_​Images_​in_​Databases 

This workflow demonstrates how to read/write PNG images from/to a database.

Icon04_​Binning_​in_​Databases 

This workflow demonstrates the different database binner nodes that allow you to create new binning columns for numerical columns. An example would be […]

Icon05_​Pivoting_​in_​Databases 

This workflow creates an SQL statement that generates a pivot table. A pivot table allows you to quickly summarize your data based on a pivot, aggregation […]

Icon06_​Sampling_​in_​Databases 

This workflow creates an SQL statement that allows you to extract a sample of data from a database. The node also supports stratified sampling, which is the […]