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

35 results

Filter
Filter by tag
H2
Database SQL Database preprocessing Education Databse Update Create
  1. Go to item
    Workflow
    Will they blend? MS Access - H2
    Database Microsoft access H2
    +1
    This workflow blends data between two different relational DBMS in KNIME Analytics Platform. It focuses on two common relational …
    knime > Examples > 01_Data_Access > 02_Databases > 07_MSAccess_meets_H2
    2
    knime
  2. 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
    mlauber71
  3. 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
    1
    mlauber71
  4. Go to item
    Workflow
    Database - Solution
    Database H2 Database preprocessing
    +1
    Solution to the exercise 11 for KNIME User Training - Writing data into a database - Reading data from a database - Aggregating d…
    tenalf > Public > L2-DS KNIME Analytics Platform for Data Scientists - Advanced > solutions > 11. Database - solution
    0
    tenalf
  5. Go to item
    Workflow
    Will they blend? MS Access - H2
    Database Microsoft access H2
    +1
    This workflow blends data between two different relational DBMS in KNIME Analytics Platform. It focuses on two common relational …
    haoran > Public > 01_Data_Access > 02_Databases > 07_MSAccess_meets_H2
    0
    haoran
  6. Go to item
    Workflow
    Demonstrates the use of DB Update and DB Merge
    H2 Update Merge
    +2
    Demonstrates the use of DB Update and DB Merge
    kathrin > Forum Questions > DB-Merge-Update-Write
    0
    kathrin
  7. Go to item
    Workflow
    Titanic KNIME Beispiel (deutsch) - SQL Datenbanken mit KNIME
    Knime Titanic Einführung
    +6
    Titanic: Machine Learning from Disaster https://www.kaggle.com/c/titanic Einführung in KNIME (deutsch) - https://hub.knime.com/ml…
    mlauber71 > Public > knime_einfuehrung_beispiel_titanic > m_150_sql_database_titanic
    0
    mlauber71
  8. Go to item
    Workflow
    Database - Solution
    Database H2 Database preprocessing
    +1
    Solution to the exercise 11 for KNIME User Training - Writing data into a database - Reading data from a database - Aggregating d…
    kzhqtt > Public > WA_Fn-UseC_-IT-Help-Desk > Database
    0
    kzhqtt
  9. Go to item
    Workflow
    Database
    Database H2 Database preprocessing
    +1
    Exercise 11 for KNIME User Training - Writing data into a database - Reading data from a database - Aggregating data in a databas…
    martyna > Training > L2-DS Training > exercises > 04. Database
    0
    martyna
  10. Go to item
    Workflow
    Database - Solution
    Database H2 Database preprocessing
    +1
    Solution to the exercise 11 for KNIME User Training - Writing data into a database - Reading data from a database - Aggregating d…
    martyna > Training > L2-DS Training > solutions > 04. Database - solution
    0
    martyna
  11. Go to item
    Workflow
    Database - Exercise
    Database H2 Database preprocessing
    +1
    Exercise 11 for KNIME User Training - Writing data into a database - Reading data from a database - Aggregating data in a databas…
    knime > Education > Courses > L2-DS KNIME Analytics Platform for Data Scientists - Advanced > exercises > 11. Database - Exercise
    0
    knime
  12. Go to item
    Workflow
    Database - Solution
    Database H2 Database preprocessing
    +1
    Solution to the exercise 11 for KNIME User Training - Writing data into a database - Reading data from a database - Aggregating d…
    knime > Education > Courses > L2-DS KNIME Analytics Platform for Data Scientists - Advanced > solutions > 11. Database - solution
    0
    knime
  13. Go to item
    Workflow
    forum 44727 - 01 Practicing with Traditional Databases
    Big data Database H2
    +3
    forum 44727 - 01 Practicing with Traditional Databases
    mlauber71 > Forum > 2022 > kn_forum_44727_l4_bd_course_practice_db_tables
    0
    mlauber71
  14. Go to item
    Workflow
    convert Long value to string to use it in DB query (forum 44798)
    Db Database Long
    +4
    convert Long value to string to use it in DB query (forum 44798)
    mlauber71 > Forum > 2022 > kn_forum_44798_database_long_value
    0
    mlauber71
  15. Go to item
    Workflow
    Transform a MySQL dump to H2 (local) database using KNIME
    Mysql Dump H2
    +5
    OK, I built something since the mentioned examples are not straightforward (if you want to play around with them further in a sub…
    mlauber71 > Public > forum > kn_forum_mysqldump_import
    0
    mlauber71
  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
    mlauber71
  17. Go to item
    Workflow
    Database
    Database H2 Database preprocessing
    +1
    Exercise 11 for KNIME User Training - Writing data into a database - Reading data from a database - Aggregating data in a databas…
    tenalf > Public > L2-DS KNIME Analytics Platform for Data Scientists - Advanced > exercises > 11. Database
    0
    tenalf
  18. Go to item
    Workflow
    example demonstrating how to manually enter a selected table and columns - or provide them via a configuation file
    H2 Select Component
    example demonstrating how to manually enter a selected table and columns - or provide them via a configuation file THX to KNIME f…
    mlauber71 > Forum > 2021 > kn_forum_36416_table_parameters
    0
    mlauber71
  19. Go to item
    Workflow
    use H2 to produce a Position / Rank number within a group variable (window functions)
    Position Rank Nulls
    +6
    use H2 to produce a Position / Rank number within a group variable (window functions) use custom JDBC driver - THX tobias.koetter…
    mlauber71 > Public > forum > kn_forum_31608_h2_group_rank_window_function
    0
    mlauber71
  20. Go to item
    Workflow
    Insert update with KNIME only nodes by an ID
    H2 Refernce Row
    +4
    Insert update with KNIME only nodes by an ID
    mlauber71 > Public > forum > kn_forum_32016_insert_on_duplicate
    0
    mlauber71

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 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 Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits