Hub

34 results

Filter
H2
Database SQL Database preprocessing Education Databse
+2
  1. 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
  2. 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
  3. 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…
    knime > Education > Courses > L2-DS KNIME Analytics Platform for Data Scientists - Advanced > exercises > 11. Database
    0
  4. 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
  5. 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 > L2-DS KNIME Analytics Platform for Data Scientists - Advanced > WA_Fn-UseC_-IT-Help-Desk > Database
    0
  6. 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
  7. 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…
    lilipertiwi > Public > KNIMEUserTraining > solutions > 10. Database - solution
    0
  8. Workflow
    Example how to use H2 database with a uuid unique identifier
    H2 Sql Create
    +6
    Example how to use H2 database with a uuid unique identifier
    mlauber71 > Forum > 2021 > kn_forum_36064_db_h2_use_uuid_unique_identifier
    0
  9. Workflow
    Example of H2 database - handling of database structure and use of Primary Keys - insert only new lines by ID
    H2 Sql Create
    +5
    Example of H2 database - handling of database structure and use of Primary Keys - insert only new lines by ID
    mlauber71 > Public > kn_example_db_h2_primary_key
    0
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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
  15. Workflow
    Prepare the Northwind database into a consistant H2 db to provide a database environment to play with
    H2 SQLIte Northwind
    +3
    These tables are included in the local database knime://knime.workflow/../data/Northwind_small.h2 (they all have a unique ID " id…
    mlauber71 > Public > kn_example_db_h2_prepare_northwind_db_small > m_001_prepare_northwind_db_h2
    0
  16. Workflow
    UPDATE an existing database and insert new rows with H2 - use the Northwind DB
    H2 Update Append
    +3
    UPDATE an existing database and insert new rows with H2 - use the Northwind DB
    mlauber71 > Public > kn_example_db_h2_insert_and_update
    0
  17. 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
  18. 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
  19. Workflow
    Example how to use H2 database to create table with upload and from scratch
    H2 Sql Create
    +5
    Example how to use H2 database to create table with upload and from scratch H2 is an SQL database that 'lives' in a single file o…
    mlauber71 > Public > kn_example_db_h2_create_table_from_scratch
    0
  20. 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