hi @rajvenkatesh_k , what is the origin of the two different pieces of text.
I pasted each here:
and as you can see they are different unicode characters
one is
U+03BC : GREEK SMALL LETTER MU
the other is
U+00B5 : MICRO SIGN
which explains why KNIME says they are not the same. I think you need to check on how the values are being sourced.
The attached is a possible way to resolve the specific issue by string replacing the problematic character (and also demonstrates the issue for anybody else who might want to suggest options) but ideally I’d say the data needs to be “fixed” at source.
String replace μ unicode characters.knwf (10.2 KB)
Do you have different character encodings maybe on different data sources? I’m not particularly expert on unicode and encodings, so maybe somebody else has other ideas…