23 workflows in this folder and its subfolders
January 1970 · 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 database is written to a file on the hard disk).
January 1970 · 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 entire database is written to a file on the hard disk).
March 2015 · Database - Read/Write PNG Images This workflow demonstrates how to read/write PNG images from/to a database. URL: KNIME Database Documentation https://docs.knime.com/latest/db_extension_guide/index.html TAGS: database,sqlite,image handling
December 2015 · Database Binning This workflow demonstrates the different database binner nodes that allow you to create new binning columns for numerical columns. An example would be to convert a numerical column, which contains the age in years, into a categorical column with values such as children and adults. T…
December 2015 · 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 and value columns.
December 2015 · 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 preferred way to sample from populations with varying subpopulation sizes.
January 1970 · Database Jam Session This workflow jams together data from not one, not two, but six databases! They are: MySQL, MongoDB, MS SQL Server, MariaDB, Oracle, PostgreSQL. The use case is a Next Best Offer, modeling the likelihood of a customer to buy a second product. This workflow is a variation of the…
April 2017 · Will They Blend? Teradata Aster - KNIME Table Today's challenge is to blend the data between a Teradata Aster database and a KNIME table in the KNIME Analytics Platform. Why these two? Teradata Aster is a database system in use at many companies around the world, and KNIME tables are an easy way to…
August 2017 · Google Big Query meets SQLite. The business of baseball games. This workflow graphically explores attendance at baseball games together with weather conditions and calendar information using a bar chart and a sunburst chart. Attendance data are stored in a Big Query Database. Weather conditions data…
April 2017 · Snowflake meets Tableau This workflow implements a DWH operation, configuring and launching a Snowflake in-cloud data warehouse instance. Sales orders are read from an Excel file, return orders supplied from our e-commerce platform's API in JSON format are filtered out, all the clean correct orders…