Hub

118 results

Filter
Column
Excel Expression Java Exist Guess
+12
  1. Node / Manipulator
    Table Manipulator
    Manipulation Column Streamable
    Allows to perform several column transformations on any number of input tables such as renaming, filtering, re-ordering and type …
    5
  2. Node / Manipulator
    Joiner
    Manipulation Column Split & Combine
    This node combines two tables similar to a join in a database. It combines each row from the top input port with each row from th…
    4
  3. Node / Manipulator
    String Manipulation
    Manipulation Column Convert & Replace
    +1
    Manipulates strings like search and replace, capitalize or remove leading and trailing white spaces. Examples: To remove leading …
    4
  4. Node / Manipulator
    Math Formula (Multi Column)
    Manipulation Column Convert & Replace
    +1
    The Math Formula (Multi Column) node is an extension of the Math Formula node which evaluates a mathematical expression based on …
    3
  5. Node / Manipulator
    String Manipulation (Multi Column)
    Manipulation Column Convert & Replace
    +1
    The String Manipulation (Multi Column) node is an extension of the String Manipulation node, applying the provided expression to …
    3
  6. Node / Manipulator
    Column Resorter
    Manipulation Column Transform
    +1
    This node changes the order of the input columns, based on user defined settings. Columns may be shifted in single steps left or …
    2
  7. Node / Manipulator
    Math Formula
    Manipulation Column Convert & Replace
    +1
    This node evaluates a mathematical expression based on the values in a row. The computed results can be either appended as new co…
    2
  8. 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
  9. 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
  10. Node / Manipulator
    Case Converter
    Manipulation Column Transform
    +1
    This node converts alphanumeric characters to lowercase or UPPERCASE.
    1
  11. Node / Manipulator
    Column Rename (Regex)
    Manipulation Column Convert & Replace
    +1
    Renames all columns based on a regular expression search & replace pattern. The search pattern is a regular expression, possibly …
    1
  12. Node / Manipulator
    Domain Calculator
    Manipulation Column Convert & Replace
    Scans the data and updates the possible values list and/or the min- and max values of selected columns. This node is useful when …
    1
  13. Node / Manipulator
    Joiner (deprecated)
    Manipulation Column Split & Combine
    This node joins two tables in a database-like way. The join is based on the joining columns of both tables.
    1
  14. Node / Manipulator
    Number Formatter
    Community Nodes HCS Tools Data Manipulation
    +1
    This node needs one column with the numbers that need to be modified. The node will create a new sortable string column or replac…
    1
  15. Node / Manipulator
    Number To String
    Manipulation Column Convert & Replace
    +1
    Converts numbers in a column (or a set of columns) to strings. Note that for an advanced configuration, such as rounding or repre…
    1
  16. Node / Manipulator
    Target Shuffling
    Manipulation Column Convert & Replace
    This node performs Target Shuffling by randomly permuting the values in one column of the input table. This will break any connec…
    1
  17. Node / Manipulator
    One to Many
    Manipulation Column Transform
    Transforms all possible values in a selected column each into a new column. The value is set as the new column's name, the cell v…
    1
  18. 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
  19. 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
  20. 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