Hub

176 results

Filter
Data manipulation
String manipulation Math formula Rule engine Column expressions Transformation
+3
  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
    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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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