Can we filter the text which is mostly same?

[PankajChaudhary]

I have a table like this

When I am using Group By node on S.no and Name
it is given table like this

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

[Snowy]

If the issue just appears to be a ‘.’, then you could run the String Manipulation node prior to the Group By with:
replace(column,".","")
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.

[Daniel_Weikert]

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