Hub

224 results

Filter
ETl
Education SQLite Join Preprocessing Database
+4
  1. 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. 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
  3. 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
  4. 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
  5. 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
  6. 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. 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. 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
  9. 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. 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
  11. 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
  12. 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
  13. 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
  14. Workflow
    Working With Collections - Collection Types
    ETL Collection Collection types
    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 > 03_Working_with_Collection_Supported_Types
    1
  15. Workflow
    Groupby - Basic Data Aggregations
    GroupBy ETL Grouping
    +1
    This workflow shows basic data aggregation methods that the GroupBy node offers. We group by one or multiple attributes and apply…
    roberto_cadili > Public > Groupby - Basic Data Aggregations
    1
  16. 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
  17. 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
  18. Workflow
    Techniques for Dimensionality Reduction
    ETL Big data Data preprocessing
    +11
    This workflow performs classification on data sets that were reduced using the following dimensionality reduction techniques: - L…
    knime > Examples > 04_Analytics > 01_Preprocessing > 02_Techniques_for_Dimensionality_Reduction > 02_Techniques_for_Dimensionality_Reduction
    1
  19. Workflow
    Working With Collections - Supported nodes
    ETL Collections Set Finder
    The goal of the workflow is to demonstrate the creation and working with collection cells. It is divided into three parts. The la…
    knime > Examples > 02_ETL_Data_Manipulation > 02_Aggregations > 02_Working_with_Collection_Supported_Nodes
    1
  20. Workflow
    Basic and Advanced Usage of the Pivoting Node
    ETL Data aggregation Pivoting
    +5
    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 > Examples > 02_ETL_Data_Manipulation > 02_Aggregations > 09_Examples_for_Using_the_Pivoting_Node
    1