Hub

22 results

Filter
Query
ETL Advanced query Concatenate DB Query Concatenation
+3
  1. Workflow
    Indexing and Searching plug-in for address database cleansing
    ETL Query Indexing
    This workflow demonstrates the Indexing & Searching plugin for address database cleansing. It uses fuzzy queries to identify typo…
    knime > Examples > 02_ETL_Data_Manipulation > 05_Indexing_Searching > 03_Example_for_Fuzzy_Address_Matching
    3
  2. Workflow
    Indexing and querying data tables
    ETL Query Advanced query
    Demonstrates the power of advanced queries to filter a given data table based on the values of several columns at once. The table…
    knime > Examples > 02_ETL_Data_Manipulation > 05_Indexing_Searching > 01_Advanced_Queries
    2
  3. Node / Source
    DB Table Selector
    DB Query
    This node takes a DB Connection as input and allows to select a table or view from within the connected database. The node output…
    1
  4. Workflow
    Index and query text documents
    ETL Document query Query
    This workflow demonstrates how advanced queries can be made in a large document collection. First an index is created on the docu…
    knime > Examples > 02_ETL_Data_Manipulation > 05_Indexing_Searching > 02_Document_Queries
    0
  5. Workflow
    Incremental indexing data tables
    ETL Query Advanced query
    This workflow demonstrates how a table index can be reused in the Table Indexer node to incrementally add new entries to an alrea…
    knime > Examples > 02_ETL_Data_Manipulation > 05_Indexing_Searching > 04_Incremental_Indexing
    0
  6. Workflow
    DB Concatenate Example
    DB Query Concatenate
    +2
    This workflow demonstrates the usage of the DB Concatenate node. The node allows the user combine several database queries with a…
    knime > Examples > 01_Data_Access > 02_Databases > 22_DB_Concatenate
    0
  7. 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
  8. Node / Manipulator
    DB Apply-Binner
    DB Query
    This node allows to group numeric data into intervals - called bins. The bins are defined in the PMML Model. This node is typical…
    0
  9. Node / Manipulator
    DB Auto-Binner
    DB Query
    This node allows to group numeric data into equidistant intervals - called bins. Please use the "DB Numeric-Binner" node if you w…
    0
  10. Node / Manipulator
    DB Column Filter
    DB Query
    This node allows columns to be filtered from the input DB Data object so that the SQL result will only contain the remaining colu…
    0
  11. Node / Manipulator
    DB Column Rename
    DB Query
    Rename database column names. The dialog allows you to change the name of individual columns by editing the text field. A configu…
    0
  12. Node / Manipulator
    DB Column Rename (Regex)
    DB Query
    Renames all columns based on a regular expression search & replace pattern. The search pattern is a regular expression, and can p…
    0
  13. Node / Manipulator
    DB Concatenate
    DB Query
    This node concatenates two database tables. The table at inport 0 is given as the first input table (top input port), the table a…
    0
  14. Node / Manipulator
    DB GroupBy
    DB Query
    This node allows rows to be grouped by the selected columns from the input DB Data object. Within the dialog, an SQL GROUP BY cla…
    0
  15. Node / Manipulator
    DB Joiner
    DB Query
    This node joins two DB Data tables. The join is based on the joining columns of both tables.
    0
  16. Node / Manipulator
    DB Numeric-Binner
    DB Query
    For each column a number of intervals - known as bins - can be defined. Each of these bins is given a unique name (for this colum…
    0
  17. Node / Manipulator
    DB Partitioning
    DB Query
    This node split rows from a DB Data table. The dialog enables you to specify the number of rows to split and the splitting strate…
    0
  18. Node / Manipulator
    DB Pivot
    DB Query
    This node pivots the input DB Data table using the selected of columns for grouping and pivoting. The group columns will result i…
    0
  19. Node / Manipulator
    DB Query
    DB Query
    Modifies the SQL query that defines the incoming DB Data table. The incoming SQL query is represented by the place holder #table#…
    0
  20. Node / Manipulator
    DB Row Filter
    DB Query
    This node allows rows to be filtered from the input DB Data table so that the resulting DB Data table will only contain the rows …
    0