Can we filter the text which is mostly same?

I have a table like this
Screenshot 2021-02-09 201844

When I am using Group By node on and Name
it is given table like this
Screenshot 2021-02-09 202058

but I need only two rows for that it should merge the same look like Name
Can we do that in KNIME?

If the issue just appears to be a β€˜.’, then you could run the String Manipulation node prior to the Group By with:
Or if it’s multiple characters, you could use the replaceChars() function.

I think the above would be the most simple solution. If your dataset is more complex, please share some of the nuances and we can help find the appropriate solution.

1 Like

There is a string similarity node in KNIME. Maybe that helps

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.