I am quite new at working with Knime and currently come across a dataset with different formattings (sometimes “,” as decimal and “.” as thousand separator, sometimes the other way around - each depending on 1| string of another column AND 2| substrings in same column). With which Knime node could I formulate conditional statements with replacing substrings according to my conditions?
For an example please look at the attached picture (input, explanation and the desired output):
Many thanks in advance for your support - highly appreciated.
I’m not aware of a single node that would implement what you are aiming for. However, such operations are always possible with different operations on different subsets of the data. see attached an example for the logic that you are interested in: forum_14241.knwf (24.1 KB)
EDIT: In fact, one can implement the whole logical sequence in a single Column Expressions node. Here is an example: forum_14241.knwf updated) (55.5 KB)
Many thanks for your quick and thorough help - highly appreciated. It works perfectly.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.