Hi @suri789    I think you haven't shared the full code, sample data and expected output to provide a solution. Please share the code proper format.   ... View more

Hi @suri789 these both are different values, I didn't see any duplicate in these.  so plainfield s plainfiled  Also from the output, I didn't see any duplicate values, all are distinct by the values..!   +----------------+ | value | +----------------+ | s plaindield| | n plainfield| | west home land| | newyork| | so plainfield| |north plainfield| +----------------+   Please note: "n plainfield & north plainfield or s plainfield & so plainfield" are different values, because we didn't write any custom logic like 'n' means 'north' or 's' means 'so'.    ... View more