Is there a list of supported functions and examples available in the GitHub repositories somewhere? I am trying to build a simple dropdown formula builder UI tool in Excel to more easily construct and order conditional manipulations.
and welcome to KNIME Community!
List of available function in Column Expressions node together with examples is give in node configuration by clicking function button and selecting certain function. Is that what you are looking for or what cause I’m a bit confused on your comments regarding developing UI tool?
Basically what I am doing is building a dropdown controlled excel spreadsheet that uses simple descriptions to write and order a series of complex expressions without needing to learn the syntax. It was something that I built in Alteryx that I am trying to translate to KNIME. Basically a user selects a field, then can select operator and function options for that data type, then they can select from the dropdown of existing values in that field or write their own. I include priority settings to allow users to easily reorder their rules.
I call my approach the “Change Engine”. There are no if statements, no real syntax and it typically processes quickly because it cascades complex formulas into a series of simple ones. It essentially matches a series of multiple AND/OR criteria tests and then applies a series of changes across multiple fields. The same process can be repeated on the failed rows to allow for “else if” functionality, although that can easily be done by copying and pasting criteria tests as well. The user selects a field, a simple description of a function allowed for that field type, and then selects from the existing data values / field names / manual entry. A first time non-technical user can quickly narrow in on a specific target of rows and perform mulit-field changes on the fly without going back to the data for reference.
I am an advanced Alteryx user, but I am just getting started in KNIME. Rebuilding this Change Engine macro and excel controller in KNIME is my first big challenge.
That was my 1st stop when considering moving to KNIME. It was very helpful. Especially the comparable tool spreadsheet.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.