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

176 results

Filter
Data manipulation
String manipulation Math formula Rule engine Column expressions Transformation
+3
  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
    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
    3
  3. 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
    3
  4. 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
  5. 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
  6. Go to item
    Workflow
    Compare Two Tables
    Data Manipulation Comparison Table Validation
    This workflow compares 2 tables with same structure meaning they have same number of columns and matching columns have same names…
    ipazin > Public > 2019_10_03_Comparing_Two_Tables
    2
  7. 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
  8. Go to item
    Workflow
    Adding Missing Records
    Pivoting Unpivoting Missing records
    +1
    This workflow demonstrates how to use Pivoting/Unpivoting nodes to add missing records into data set. In case there is only one v…
    ipazin > Public > 2020_10_12_Adding_Missing_Records
    1
  9. Go to item
    Workflow
    All in One Row
    One Row Data Manipulation
    This workflow transforms input table with n rows and m columns to 1 row and n times m columns using lists. Second row is appended…
    ipazin > Public > 2019_09_05_All_in_One_Row
    1
  10. Go to item
    Workflow
    Matching Headers
    Matching Headers Incoming vs. Template Headers JavaScript Views
    +1
    This workflow demonstrates how to use JavaScript nodes in interactive Component's view to match incoming headers with template he…
    ipazin > Public > 2021_02_15_Matching_Headers
    1
  11. Go to item
    Workflow
    From Excel to KNIME table Unpivoting
    Data Manipulation Unpivoting Excel Processing
    +1
    This workflow demonstrates how to convert specific Excel table format to desired one using KNIME Unpivoting node. To get proper f…
    ipazin > Public > 2020_10_22_From_Excel_to_KNIME_Table_Unpivoting
    1
  12. Go to item
    Workflow
    Joiner in a Loop
    Array Flow Variables Data Manipulation Joiner in a Loop
    +1
    This workflow demonstrates how to setup up and configure nodes in order to always join two tables based on all columns. Column Fi…
    ipazin > Public > 2020_10_26_Joiner_In_A_Loop
    1
  13. Go to item
    Workflow
    Column Expressions for Data Manipulation
    ETL Data manipulation Data transformation
    +8
    This is an example worklow to manipulate string values, transform numeric values, and generate new columns using the following: 1…
    knime > Examples > 02_ETL_Data_Manipulation > 04_Transformation > 03_Column_Expressions_for_Data_Manipulation
    1
  14. Go to item
    Workflow
    Removing Special Words from Multiple Columns
    Data Manipulation Data Cleaning Multi Column
    +2
    This workflow demonstrates how to remove i.e. clean multiple columns removing all words listed in reference table found in Input …
    ipazin > Public > 2020_09_17_Removing_Special_Words_from_Multiple_Columns
    1
  15. 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
  16. Go to item
    Workflow
    Split Numbers vs Strings
    Data Manipulation RegEx
    This workflow demonstates how to split number against string values from same column and place them in new ones. Main logic is co…
    ipazin > Public > 2020_08_05_Split_Numbers_vs_Strings
    1
  17. Go to item
    Workflow
    Rename Columns by Position
    Data Manipulation Rename Columns by Position Column Headers
    This workflow demonstrates how to rename columns by position by using mapping table together with Extract and Insert Column Heade…
    ipazin > Public > 2020_11_26_Rename_Columns_By_Position
    1
  18. Go to item
    Workflow
    Wildcard Reference Row Filtering
    Reference Row Filtering Data Manipulation Regular Expressions
    +1
    This workflow demonstrates how to filter input data based on keywords from the reference table. When exact match is needed Refere…
    ipazin > Public > 2021_03_11_Wildcard_Reference_Row_Filtering
    1
  19. Go to item
    Workflow
    04 Numbers Strings and Rules
    Data manipulation Transformation Rule engine
    +3
    Exercise for data transformation. Perform data manipulation operations with the Rule Engine, Math Formula, String Manipulation, a…
    km_tan > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Exercises > 04 Numbers Strings and Rules
    0
  20. Go to item
    Workflow
    03 Row and Column Filtering
    Row filter Column filter Data manipulation
    Exercise for row and column filtering
    momenibd > IT 4015 momenibd projects > Lab 1 > Custom Data Flows > 03 Row and Column Filtering
    0

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