Replaces cells in a column according to dictionary table (2nd input). The node has two inputs: The first input contains a target column whose values are to be replaced using the dictionary table (2nd input). From the dictionary table, choose one column (or the rowID column) that is used as lookup criterion and an output column that contains the corresponting replacement. Any occurrence in the target column (1st input) that matches the lookup value is replaced by the corresponding value of the output column, which is another column in the dictionary table.
When the lookup column is of type String, it's also possible to replace the cell if
Note that the Substring, Wildcard and RegEx methods bring a significant performance penalty, since every target cell must be checked against every lookup cell.
When matching with strings, it is possible to match either case-sensitively or ignore case.
Instead of replacing the target column, the column containing the replacements can be appended instead. Furthermore, a column indicating whether the value was found (and therefore replaced) can be appended.
Missing values are treated as ordinary values, that is, they are valid as lookup and replacement value. If there are duplicates in the lookup column in the dictionary table, the last occurrence (bottom most row) defines the replacement pair.
If the input/lookup column is a collection type, each of the contained values in the collection is a search element.
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.
A zipped version of the software site can be downloaded here.
Do you have feedback, questions, comments about NodePit, want to support this platform, or want your own nodes or workflows listed here as well? Do you think, the search results could be improved or something is missing? Then please get in touch! Alternatively, you can send us an email to firstname.lastname@example.org, follow @NodePit on Twitter, or chat on Gitter!
Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.