Node Guide

Common Type Files

• Data Loading Example
• Read a CSV file
• Read an XLS file
• Use the File Reader
• Read all sheets from an XLS file in a loop
• Table Reader

Databases

• Database Simple IO Example
• Database Advanced Example
• Read and Write PNG Images in Databases
• Binning in Databases
• Pivoting in Databases
• Sampling in Databases

Data Generation

• Generating clusters with Gaussian distribution
• Parallel Generation of a Data Set containing Clusters
• Data generation model example
• Generating random missing values in an existing data set
• Generation of data set with more complex cluster structure
• Random combination of two sets of data
• Splitting data and rejoining for manipulating only subpart
• Generating data sets containing association rules
• Generating a Shopping Market Data Set
• Advantages of Quasi Random Sequence Generation

Structured Data

• Basic XML processing with XPath
• XML processing (Bush books) XPath
• XML meets JSON

REST Web Services

• Data API Using REST Nodes
• IBM Watson News-Google News

ZIP and Remote Files

• Amazon S3 Remote File Example
• Azure Blob Store Remote File Example
• ZIP Local vs remoteHTTP
• AmazonS3-MSBlobStorage Census Data

WebLog Files

• Example for Apache Logfile Analysis

Basic Examples

• Example for Standard Preprocessing

Filtering

• Validating Datatables
• Column Filter
• Row Filtering
• Advanced Row Filters

Aggregations

• Working with Collection Creation and Conversion
• Working with Collection Supported Nodes
• Working with Collection Supported Types
• Generating a Ranking value
• Calculating Rank Correlations
• Basic Examples for Using the GroupBy Node
• Advanced Usage of the GroupBy node

Joining and Concatenating

• Concatenate
• Joiner

Transformation

• Handling Missing Values

Indexing Searching

• Advanced Queries
• Document Queries
• Example for Fuzzy Address Matching

Date and Time Manipulation

• Generate Fixed Time Intervalls

Geolocation

• Static geolocation of IP addresses
• Dynamic geolocation of IP addresses
• GeoIP Visualization using Open Street Map (OSM)
• Visualization of the World Cities using Open Street Map (OSM)
• Visualizing Routes and Tracks with OSM
• Google Geocode API-OSM-text file

Preprocessing

• Feature Elimination with Naive Bayes
• Techniques for Dimensionality Reduction
• Perform Feature Selection

Statistics

• Simple Example with Statistics
• Example for Statistical Tests
• Calculating the Cronbach Alpha
• Performing a Linear Discriminant Analysis

Clustering

• Performing a k-Means Clustering
• Performing a k-Medoids Clustering

Classification and Predictive Modelling

• Example for Learning a Decision Tree
• Example for Learning a Neural Network
• Example for Learning a Naive Bayes Model
• Exporting a Decision Tree as Image
• Gradient Boosted Trees

Regressions

• Learning a Simple Regression Tree

Time Series

• Example of Time Series Functionality
• Example for Predicting Time Series

PMML

• Example for Using PMML for Transformation and Prediction

Optimization

• Cross Validation with SVM
• Optimizing Subset Selection
• Parameter Optimization
• Meassuring Variable Importance
• Score Erosion for Multi Objective Optimization

Active Learning

• Active Learning PBCA default
• Active Learning PBCA modular Score
• Active Learning Uncertainty Sampling

Meta Learning

• Combining Classifiers using Prediction Fusion
• Learning a Random Forest
• Learning a Tree Ensemble Model
• Cross-Platform Ensemble Model

Deep Learning

• Basic Concepts Of Deeplearning4J Integration
• Basic Learner View Tutorial
• Network Example Of A Simple MLP
• Network Example Of A MLP For Images
• Network Example Of A Simple Convolutional Net
• Calculate Document Distance Using Word Vectors
• Simple Document Classification Using Word Vectors
• Sentiment Classification Using Word Vectors
• Simple Anomaly Detection Using A Convolutional Net
• Simple Regression Of Simple Functions
• Housing Value Prediction Using Regression
• Font Detection Using A Convolutional Net
• Celebrity Detection Using Alex Net

BIRT

• Simple Example for Reporting
• Example for Reporting
• Example for a Chemical Report
• Report with Radarplot and R
• Using KNIME Colors in BIRT Report
• Report for Soccer Data with R

Meta Nodes and Wrapped Nodes

• Simple Streaming and Wrapped Nodes

Flow Variables

• Using Flow Variables for the Time Range
• Using Flow Variables to control Execution Order

Loops

• Loop over a set of parameter for k means
• Example for Reading a List of Files
• Looping over all columns and manipulation of each
• Looping for Multiple Target Prediction
• Write each row in one file
• Writing a data table column wise to multiple csv files
• Example for Recursive Looping
• Example for Recursive Replacement of Strings
• Looping over Chunks of the Data
• Looping a fixed number
• Looping over Groups of the Data
• Using TableRows as FlowVariables in Loop
• Usage of Generic Loop Start
• Looping over defined Intervals
• Collecting Columns in Loop
• Collecting Variables in Loop
• Usage of Breakpoint in Loops
• Recover from Breakpoint in Loop

Switches

• Case Switch
• Using a If Switch
• Using JAVA for If Switch
• Switch on Empty Tables

External Applications

• Example for the external tool (Linux or Mac only)

Java

• Example of Java Snippet

R

• Example of R Snippet

Python

• Using Python Script in Databases

Text Processing

• Document clustering
• Document Classification
• Sentiment Classification
• Dictionary based Tagging
• Named Entity Tag Cloud
• NY Times RSS Feed Tag Cloud
• Sentiment Classification with NGrams
• Streaming Sentiment Classification
• Fuzzy String Matching
• Discover Secret Ingredient
• Lemmatizer Preprocessing
• DocumentVector FeatureSpaceAdaption
• DocumentVector Hashing
• NER Tagger Model Training
• RSS Feed Reader
• Tika Parsing

Chemistry and Life Sciences

• Example for using MoSS

Social Media

• Twitter meets PostgreSQL

Network Mining

• Create Network from Edge Table
• Filtering in Networks
• Looping in Networks
• Networks and Prediction
• DrugBank Network analysis
• Clustering Networks based on Distance Matrix
• Pubmed Author Network Analysis
• Schools Wiki Network Analysis
• Schools Wiki Partition Analysis

Semantic Web

• Read and write triples from and to file
• SPARQL SELECT Query from different endpoints
• SPARQL INSERT Query from table
• SPARQL INSERT from file
• SPARQL Queries and named graphs
• SPARQL UPDATE Query
• SPARQL DELETE Query
• SPARQL Executor
• Doing a large Query on a public endpoint
• Using Semantic Web to generate Simpsons TagCloud
• Semantic Web Analysis Accessing DBpedia

Server

• Generate a Report and Save the File
• Write files into the Server Repository

WebPortal

• Example for a Data Mining WebPortal
• Extract System and Environment Variables (Linux only)
• Quickforms to table
• Read file send as EMail
• Select most recent date and time cells
• Showing an autogenerated time series line plot
• Visualize Scatterplot on file

Big Data Connectors

• Big Data Preprocessing Example
• HDFS and File Handling Example

Spark Executor

• Spark MLlib Decision Tree
• Mass Learning Event Prediction MLlib to PMML
• PMML to Spark Comprehensive Mode Learning Mass Prediction
• Parameter Optimization in Spark
• Hive to Spark to Hive
• Modularized Spark Scripting

Credit Scoring

• CreditScoring

Churn Analysis

• ChurnAnalysis

LastFM Recommendations

• LastFM Recommendations

Social Media clustering

• Clustering the Social Community

Forum Analysis of the KNIME Forum

• Simple Statistics on KNIME Forum
• Text Classification from Forum Posts
• Applying Text and Network Analysis Techniques to Forums
• Parsing the KNIME Forum

RESTDemo

• Call Local Workflow
• Call a Workflow on a Server

Energy Usage

• Energy Usage Time Series Prediction

Forest Fire Prediction

• Forest Fire Prediction

Address Deduplication

• Deduplication of Address Data

Medical Claims

• Interactive Outlier Detection

Swiss Actuarial Example

• Swiss Actuarial Example

MarketBasketAnalysis

• Build Association Rules for MarketBasketAnalysis
• Apply Association Rules for MarketBasketAnalysis

AnomalyDetection

• Preprocessing Time Alignment and Visualization
• Time Series AR Training
• Time Series AR Deployment
• Creating a ControlChart of a Time Series

Churn Prediction

• Training a Churn Predictor
• Deploying the Churn Predictor

TwitterAnalysis

• Collecting data from Twitter
• Analyzing Twitter Data

Model Selection and Management

• Model Selection Sampled

Customer Segmentation Use Case

• Basic Customer Segmentation Use Case
• Customer Segmentation Use Case

DataCleaning WebPortal

• WebPortal

Image Processing

Tutorials

Node Tutorials

Image Reader

• Image Reader
• Image Reader Table
• Image Reader subsets and series

Image Calculator

• Absolute
• Minimum
• Difference

• Basic Views
• Table Creation Mode
• Dimension Selection
• Basic Segmentation
• Feature Calculation
• Group By
• Labeling Filter
• Convolver
• Pixel Types
• Streaming
• Image Cropper
• Interactive Annotator
• Interactive Labeling Editor
• Cell Clump Splitter 2D
• Dont Save
• Projector
• Slice Loop

Application Tutorials

RGB Images

• RGB Splitting
• Image Montage

Median vs Average Filter

• Median vs Average Filter

Morphological Image Operations

• Dilate
• Erode
• Close
• Open
• Example CT Image

Masking

• Masking using Thresholder

Simple Hilite

• Simple Hilite

Interactive Segmentation View

• Basic Setup
• Advanced Setup Part 1
• Advanced Setup Part 2

Color Management

• Basic Setup
• Apply Colors
• Numeric Labels
• Feature Coloring
• Interactive Annotator

Calculations on Labelings

• Count Cells
• Measure Distances
• Nearest Neighbor
• Measure Lengths

Difference of Gaussians

• Column Selections
• Joiner Calculator
• DoG Node

Find Seeds

• Find Seeds

Gradient Magnitude

• Gradient Magnitude

Spot Detection

• Spot Detection

Overlay RGB

• Overlay RGB

Watershed Segmentation

• Watershed Segmentation

3D Segmentation

• 3D Segmentation

Integrations

ImageJ

• ImageJ

CellProfiler

• CellProfiler Colocalization
• CellProfiler CometAssay
• CellProfiler Human
• CellProfiler Speckles
• CellProfiler TrackObjects
• CellProfiler Tumor

Tess4J

• Tess4J

KNIME Python Extensions

• Python Scripting

Applications

• Trackmate
• Larva Tracking
• Bouncing Ball
• Car Counting
• Count Chromosomes
• High Content Screening
• Intensity Measurement
• Yeast Colonies

HCS Tools

• Visualization of screening data
• Metadata utilities for screening data
• Normalization of screening data
• Quality Control
• Dose Response
• Visualization of screening data 2

RDKit

• Clustering
• Reaction Enumeration
• Template Enumeration
• Chemical Transformations
• Working In 3D
• Find Scaffolds And Sidechains