Combining similar rows into one.

Hello,
I am trying to combine the same region names here. If you see i have additional region names ending with (P). So i want to combine them.
For example, Eastern Asia and Eastern Asia (P) should be one row.

I hope you understand and anyone can help me.

Thanks.

hi @Shana100 , welcome to the community
Iā€™m attaching a simple workflow for you to start with.
image
KNIME_project14.knwf (92.3 KB)

happy knimining
rgds

1 Like

hi @marzukim , thank you for responding to me. This helped me to solve my problem.
Thank youu

1 Like