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

229 results

Filter
ETL
Education SQLite Join Preprocessing Database
+4
  1. Go to item
    Workflow
    Transform Data using GroupBy and Joiner nodes
    ETL KNIME Data manipulation
    +7
    In this workflow, a number of ETL operations are performed on the sales2008-2011.csv dataset. Besides showing what ETL features a…
    knime > Beginners Space > 03_Transform > 01_Transform_Using_Group_By_and_Joiner_nodes
    9
  2. Go to item
    Workflow
    Transform Data using Rule Engine and String Manipulation nodes
    ETL String Manipulation Rule Engine
    +5
    This Workflow demonstrates the usage of "String Manipulation" and "Rule Engine" nodes for data transformation. The objective of t…
    knime > Beginners Space > 03_Transform > 03_Transform_Using_Rule_Engine_and_String_Manipulation_Node
    8
  3. Go to item
    Workflow
    Transform Data using Pivoting node
    ETL Data aggregation Pivoting
    +8
    Create a pivot table with one or more group columns and one or more pivot columns. Apply basic aggregation methods like sum and c…
    knime > Beginners Space > 03_Transform > 02_Transform_Using_the_Pivoting_Node
    8
  4. Go to item
    Workflow
    Filter Timeseries Data Using Flow Variables
    ETL Data manipulation Date
    +1
    This workflow demonstrates using flow variables in the date and time nodes. Here the use case is to filter the last full week of …
    knime > Examples > 02_ETL_Data_Manipulation > 06_Date_and_Time_Manipulation > 04_Filter_TimeSeries_Data_Using_FlowVariables
    4
  5. Go to item
    Workflow
    String Manipulation, Math Formula and Rule Engine Example
    ETL Data manipulation String manipulation
    +7
    This workflow shows three different data manipulation operations, namely: - create three categories of people based on their week…
    knime > Examples > 02_ETL_Data_Manipulation > 04_Transformation > 02_StringManipulation_MathFormula_RuleEngine
    4
  6. Go to item
    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
  7. Go to item
    Workflow
    Duplicate Row Filter
    Duplicates Data manipulation Duplicate row filter
    +2
    This workflow is based on the adult.csv data set. Try it out to: 1. Remove duplicates - keep the first or last appearance of the …
    knime > Examples > 02_ETL_Data_Manipulation > 01_Filtering > 08_Filtering_Duplicates
    3
  8. Go to item
    Workflow
    Timesheets Aggregation & Analysis
    Date&time Manual table manipulation Timesheets
    +9
    This workflow reads timesheets from Excel files stored on Google Drive and additional information about employees and projects fr…
    knime > Finance, Accounting, and Audit > Timesheets Aggregation & Analysis
    2
  9. Go to item
    Workflow
    Analytics - Model Selection to Predict Flight Departure Delays
    Data science Machine learning Model selection
    +4
    This workflow trains a number of data analytics models and automatically selects the best model to predict departure delays from …
    knime > Examples > 50_Applications > 28_Predicting_Departure_Delays > 01_Analytics
    2
  10. Go to item
    Workflow
    Join example workflow
    Join Joiner Cross join
    +6
    A Joiner node joins two tables together based on one or more common key values. Possible join modes: inner join, left outer join,…
    knime > Examples > 02_ETL_Data_Manipulation > 03_Joining_and_Concatenating > 02_Joiner
    2
  11. Go to item
    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
  12. Go to item
    Workflow
    Table Difference Finder
    ETL Data manipulation String manipulation
    +1
    This workflow shows the usage of Table Difference Finder node. A csv file is read in. The data are modified in one branch: - all …
    knime > Examples > 02_ETL_Data_Manipulation > 04_Transformation > 05_TableDifference_Finder
    2
  13. Go to item
    Workflow
    Example Workflow for ETL Basics Operations
    ETL KNIME Data manipulation
    +2
    In this workflow, a number of ETL operations are performed on the sales2008-2011.csv dataset. Besides showing what ETL features a…
    knime > Examples > 02_ETL_Data_Manipulation > 00_Basic_Examples > 02_ETL_Basics
    2
  14. Go to item
    Workflow
    Importing Data - Solution
    ETL Data access Import
    +8
    Solution to the exercise 1 for KNIME User Training - Import data from three different file formats (table, csv, xls) - Import dat…
    knime > Education > Courses > L1-DS KNIME Analytics Platform for Data Scientists - Basics > solutions > 01. Importing Data - Solution
    1
  15. Go to item
    Workflow
    Workflow to show Row Filtering examples
    Row Filter Row Filtering ETL
    Based on the adult.csv data set: 1. Exclude rows where marital-status is missing. 2. On the remaining rows: a. extract rows where…
    knime > Examples > 02_ETL_Data_Manipulation > 01_Filtering > 05_More_Row_Filter_Examples
    1
  16. Go to item
    Workflow
    Workflow to show Column Filter examples
    Column filter ETL Column filtering
    This workflow is based on adult.csv data set and demonstrates column filter examples using manual selection with a Column Filter …
    knime > Examples > 02_ETL_Data_Manipulation > 01_Filtering > 06_More_Column_Filter_Examples
    1
  17. Go to item
    Workflow
    Concatenation example
    Concatenation Data manipulation ETL
    We have two datasets containing sales records. The first data set has sales records from 2008 to beginning of 2011. The second da…
    knime > Examples > 02_ETL_Data_Manipulation > 03_Joining_and_Concatenating > 01_Concatenate
    1
  18. Go to item
    Workflow
    How to use the Rank node to compute rankings
    ETL Rank Row filter
    +1
    This workflow shows how the rank node in combination with a Row Filter node can be used to determine the rows whose ranking colum…
    knime > Examples > 02_ETL_Data_Manipulation > 02_Aggregations > 04_Generating_a_Ranking_value
    1
  19. Go to item
    Workflow
    Reading and transforming multiple Excel files from a ZIP archive
    Decompress Excel ETL
    +1
    This workflow demonstrates how to read and transform multiple files with similar file structure.
    knime > Examples > 01_Data_Access > 01_Common_Type_Files > 13_Reading and transforming multiple Excel files from a ZIP archive
    1
  20. Go to item
    Workflow
    Working With Collections - Collection creation and conversion
    ETL Collections Column Aggregator
    The goal of the workflow is to demonstrate the creation and working with collection cells. It is divided into three parts. The "C…
    knime > Examples > 02_ETL_Data_Manipulation > 02_Aggregations > 01_Working_with_Collection_Creation_and_Conversion
    1

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