Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Search

63 results

Filter
SQL
Database Education Database preprocessing H2 Life science
+2
  1. Go to item
    Workflow
    A meta collection of KNIME and databases (SQL, Big Data/Hive/Impala and Spark/PySpark)
    Database Sql Hive
    +11
    A meta collection of KNIME and databases (SQL, Big Data/Hive/Impala and Spark/PySpark) KNIME as a powerful data anaylytics platfo…
    mlauber71 > Public > _db_sql_bigdata_hive_spark_meta_collection
    1
  2. Go to item
    Workflow
    School of duplicates - and how to deal with them
    Sql Duplicates Remove
    +1
    Dealing with duplicates is a constant theme with data scientist. And a lot of things can go wrong. The easienst ways to deal with…
    mlauber71 > Public > kn_example_duplicates_school_of
    1
  3. Go to item
    Workflow
    Decision Tree with all its exports
    Machine learning Decision tree Sql
    +3
    A simple decision tree with all the possibilities to store the results (as PMML or Ruleset or SQL Code) and evaluation (ROC curve
    mlauber71 > Public > kn_example_decision_tree
    1
  4. Go to item
    Workflow
    Advanced Query Building
    Database SQL Custom query
    +1
    This workflow shows how to write custom SQL queries using KNIME database nodes with an embedded script editor. These nodes can be…
    knime > Examples > 01_Data_Access > 02_Databases > 15_Advanced_Query_Building
    1
  5. Go to item
    Workflow
    demonstrates the use of DB Update and DB Merge with MS Access DB
    Ms Access Sql
    +5
    demonstrates the use of DB Update and DB Merge with MS Access DB
    mlauber71 > Public > kn_example_db_update_merge_ms_access
    1
  6. Go to item
    Workflow
    02_Database_Data_Manipulation
    E-learning Database SQLite
    +2
    E-learning course exercise. Filter a database table directly on the database. Read the filtered data into a KNIME data table.
    burdhasp > Public > Exercises - L2-DS KNIME Analytics Platform for Data Scientists - Advanced > Exercises > 02_Database_Data_Manipulation
    0
  7. Go to item
    Workflow
    15_Database_Data_Manipulation
    E-learning Database SQLite
    +2
    E-learning course exercise. Filter a database table directly on the database. Read the filtered data into a KNIME data table.
    stervis > Public > E-Learning > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Exercises > 15_Database_Data_Manipulation
    0
  8. Go to item
    Workflow
    15_Database_Data_Manipulation - Solution
    E-learning Database SQLite
    +2
    Solution to an e-learning course exercise. Filter a database table directly on the database. Read the filtered data into a KNIME …
    stervis > Public > E-Learning > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 15_Database_Data_Manipulation - Solution
    0
  9. Go to item
    Workflow
    Database
    Database Database preprocessing Education
    +2
    Solution to "Database" exercise for basic Life Science User Training - Writing data into a database - Reading data from a databas…
    catherineoleary > Public > L1-LS KNIME Analytics Platform for Data Scientists - Life Sciences - Basics > Solutions > 05. Database - solution
    0
  10. Go to item
    Workflow
    Database
    Database Database preprocessing Education
    +2
    Solution to "Database" exercise for basic Life Science User Training - Writing data into a database - Reading data from a databas…
    janina > Customized Training > Customized Training - Life Sciences > Solutions > 05. Database - solution
    0
  11. Go to item
    Workflow
    Dynamic SQL and parameter passing
    Parameterized DB Query Reader DB Query Dynamic SQL
    +2
    Demonstration of Parameterized DB Query Reader and DB Query Reader, dynamically passing parameters and also dynamically specifyin…
    takbb > Public > Demo Workflows > Dynamic SQL and Parameter Passing
    0
  12. Go to item
    Workflow
    H2 java based database example
    H2 Database Sql
    H2 is a free database you can use with KNIME either as a file on your drive or as an in memory DB
    mlauber71 > Public > kn_example_h2_database > m_001_h2_db
    0
  13. Go to item
    Workflow
    Identify tables in you database(s) and loop over them and store the data in a CSV file
    Sql Sqlite Loop
    +2
    Identify tables in you database(s) and loop over them and store the data in a CSV file
    mlauber71 > Public > kn_example_db_loop_multiple_tables
    0
  14. Go to item
    Workflow
    MERGE an existing database and insert new rows with H2 - use the Northwind DB
    H2 Update Append
    +3
    MERGE an existing database and insert new rows with H2 - use the Northwind DB
    mlauber71 > Public > kn_example_db_h2_merge
    0
  15. Go to item
    Workflow
    Model Deployment SQL Recoding
    Deployment File Database
    +7
    This workflow demontstrates a mode of deploying a model with KNIME. The workflow reads new unseen data from a database, reads the…
    knime > Examples > 50_Applications > 27_Deployment_Options > 02_Model_Deployment_SQL_Java_recoding
    0
  16. Go to item
    Workflow
    remove duplicates with condition and add the last date
    H2 SQL Rank
    +1
    remove duplicates with condition and add the last date
    mlauber71 > Forum > 2022 > kn_forum_38543_rank_deduplicate
    0
  17. Go to item
    Workflow
    PostgreSQL - filter date variables
    Sql Postgres Postgresql
    PostgreSQL - filter date variables
    mlauber71 > Forum > 2022 > kn_forum_42766_db_postgres_date_varaible
    0
  18. Go to item
    Workflow
    Database
    Database Database preprocessing Education
    +2
    "Database" exercise for basic Life Science User Training - Writing data into a database - Reading data from a database - Filterin…
    ciaccindr > Public > Corso2022 > L1-LS > Exercises > 05. Database
    0
  19. Go to item
    Workflow
    Construct a Right Join with SQLite
    Sql Sqlite Join
    +2
    I built a workflow that does that also to play around with SQLite and to see what it could do. I have two databases that both hav…
    mlauber71 > Public > kn_example_db_sqlite_right_joiner_loop
    0
  20. Go to item
    Workflow
    H2 do an UPDATE on the server using a VIEW of the existing and the new data
    H2 Update Append
    +2
    H2 do an UPDATE on the server using a VIEW of the existing and the new data
    mlauber71 > Public > kn_example_db_h2_update_in_databse
    0

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits