How to remove duplicates in one cell?

KNIME Extensions
1

Hello,

how can I remove duplicate strings in one cell? Example: Apple, Tomato, Apple
Expected Result should be: Apple, Tomato

I want to use a manipulation to remove duplicates in a column but based on the cell content.
Is that possible?

Thank you.

2

Hi @Frank2323,

you can split the cells, unpivot the results and use group by with unique concatenate.

BR

2 Likes
3

If this is in a List Cell, then you can use the Vernalis ‘List to Set Convertor’ node:

Steve

2 Likes