Hub

20 results

Filter
Column
Excel Expression Java Name Exist Guess Header If
  1. Workflow
    Merging Exclusive Values in Various Columns into a Single Column
    Recursive loop Ungroup Aggregation
    +8
    Version 1.1 2021-02-22 There are occasions (for example, after merging several tables or after a loop workflow process) where one…
    ndwulst > Public > Merging Exclusive Values in Various Columns into a Single Column
    1
    ndwulst
  2. Workflow
    Import EXCEL - a meta workflow trying to answer questions about importing data from Excel files
    Excel Import Sheet
    +17
    Import EXCEL - This workflow will act as a meta workflow trying to answer questions about importing data from Excel files One of …
    mlauber71 > Public > kn_example_excel_import_meta_workflow
    1
    mlauber71
  3. Workflow
    20230103 Pikairos How to create a list starting from a matrix
    Unpivoting Matrix Column
    This workflow provides a solution to question asked in post #58070: How can i pass from a Matrix to a column format? The solution…
    pikairos > Public > 20230103 Pikairos How to create a list starting from a matrix
    0
    pikairos
  4. Workflow
    Collection Columns as input for Machine Learning Model
    Collection Column Machine
    +1
    Collection Columns as input for Machine Learning Model
    mlauber71 > Forum > 2022 > kn_forum_45650_ml_model_colection_column
    0
    mlauber71
  5. Workflow
    replace several blanks with a flexible number of blanks ....
    Replace String Column
    +1
    replace several blanks with a flexible number of blanks ....
    mlauber71 > Forum > 2022 > kn_forum_45697_change_blanks_flexible_number_per_column
    0
    mlauber71
  6. Workflow
    replace several missings in string
    Replace String Column
    +1
    replace several missings in string replace(column("Column1"), " "," ")
    mlauber71 > Forum > 2022 > kn_forum_45697_reduce_spaces
    0
    mlauber71
  7. Workflow
    example for Pivot table
    Pivot Table Column
    +2
    example for Pivot table also ... if you later want to change the order of your columns after a "header" (like in a Pivot table) a…
    mlauber71 > Forum > 2022 > kn_forum_38571_pivot
    0
    mlauber71
  8. Workflow
    add fields to Hive table
    Hive Sql Big data
    +2
    Use KNIME and Hive/SQL syntax to add columnd to a Big Data table (migrated to KNIME 4.0 and new DB nodes)
    mlauber71 > Public > kn_example_bigdata_hive_add_column_db_40
    0
    mlauber71
  9. Workflow
    store the selected Path as column and the file name only
    Create Folder File
    +2
    store the selected Path as column and the file name only
    mlauber71 > Public > kn_example_file_name_as_column
    0
    mlauber71
  10. Workflow
    use Python to drop columns with specific names
    Python Knime Column
    +1
    use Python to drop columns with specific names
    mlauber71 > Public > kn_example_python_filter_columns
    0
    mlauber71
  11. Workflow
    RegEx - remove line breaks and special characters from column name
    Regex Rename Column
    +5
    RegEx - remove line breaks and special characters from column name
    mlauber71 > Public > kn_example_regex_special_characters
    0
    mlauber71
  12. Workflow
    switch dot and comma in string column - and remove special characters
    Dot Comma Switch
    +4
    switch dot and comma in string column - and remove special characters replaceChars(replaceChars(replaceChars(replaceChars(column(…
    mlauber71 > Forum > 2022 > kn_forum_45693_column_expression_replace_comma
    0
    mlauber71
  13. Workflow
    Modify column names using Java Edit Variable
    Column Columns Rename
    +1
    Rename columns names using Java Edit Variable so that every column name is upper case, and all spaces are replaced by underscores…
    takbb > Public > Modify column names using Java Edit Variable
    0
    takbb
  14. Workflow
    011_Loops - 4
    Loop Conversion Column
    +2
    Example of Column List Loop - conversion of multiple columns in a loop and using a new node for the same. Checked for update: 6.4…
    laufi > Public > 011_Loops - 4
    0
    laufi
  15. Workflow
    demonstrate how to update cells in a Excel file based on the structure of another file
    Excel Cell Update
    +2
    demonstrate how to update cells in a Excel file based on the structure of another file
    mlauber71 > Forum > 2022 > kn_forum_39371_excel_cell_update
    0
    mlauber71
  16. Workflow
    Check if column is present and use if-switch accordingly
    If Switch Java
    +4
    Using Java and Rule engine and If-Switch to decide if a column is present and active which branch of a workflow should be execute
    mlauber71 > Public > kn_example_if_switch
    0
    mlauber71
  17. Workflow
    Use Java Snippet to check if Column is there, fill a FlowVariable and then activate if switch
    Column Exist Java
    +1
    Use Java Snippet to check if Column is there, fill a FlowVariable and then activate if switch
    mlauber71 > Public > kn_example_java_if_column_exists_switch
    0
    mlauber71
  18. Workflow
    Use Java Snippet to set multiple constant values at once
    Java Snippet Id
    +4
    Use Java Snippet to set multiple constant values at once
    mlauber71 > Public > kn_example_java_multiple_constant_values
    0
    mlauber71
  19. Workflow
    How to force column data type in “Excel Reader (XLS)” node?
    Excel Xls Xlsx
    +4
    I built a workflow that uses your idea and does three imports of an Excel file, one all numeric, one all strings and one guess. F…
    mlauber71 > Public > forum > kn_example_r_readxl > m_001_r_readxl
    0
    mlauber71
  20. Workflow
    Problem with KNIME and Python and leading underscore in column name
    Python Pandas Column
    +2
    Problem with KNIME and Python and leading underscore in column name
    mlauber71 > Public > forum > kn_forum_27826_python_source_issue > m_001_python_problems_with_column_names
    0
    mlauber71