(btw: I know that I could easily do the same job with a few lines in R oder spark. Running this sample on the same KNIME version on a colleagues computer works fine. I have started KNIME already mit -clean, nothing helps. Rule nodes will not work, but if you use a String Manipulation: toNull (regexReplace (x, 'N/A', '')) or a Java Snippet node (even simple): outx 'N/A'.equals (cx) null : cx it is not very hard to replace that value with null, which KNIME will interpret in these cases as missing values. I think KNIME has some kind of state in this node, at least obviously in the eclipse workspace for sure. Note that strings which are part of the expression and are not from the input data (or the result of another wrapped function call) need to be enclosed in double quotes ('''). When I came back it did not work anymore. String Manipulation (Variable) Manipulates or defines values of variables like search and replace, capitalize or remove leading and trailing white spaces. I changed basically the XMX setting in KNIME.ini, restarted KNIME and have run several other workflows. I have to say, yesterday this has worked. The warning being shown is just about the possible problem with reusing the KNIME node in a machine learning context as with R oder Spark/MLLIB because if model incompatibility problems. WARN Missing Value 2:2 The current settings use missing >value handling methods that cannot be represented in PMML 4.2 The sample workflow is primitive and looks like:Ĭonfig of the first node which reads the excel file (XLSX)Ĭonfig of the second node, which should replace the missing values: But my current problem is rather simple, I am in a 'data preparation step' where the missing value node in KNIME does not work. It is about ecommmerce transactions where a association rule analysis should be done later.
I know I can use-> replace ( field1,'',' ') but it will only work for sign. I'm running KNIME to prepare some ML data sets. I would like to do what 'Data Cleanings' function does and so remove special characters from a field with the formula function.For instance: addaro' becomes addaro, samuel becomes samuel.