Preprocessing Data for Clustering

I need to perform clustering on a given dataset (see sample 1). Since there are no clear attributes specified in the dataset, I decided to introduce binary attributes (see sample 2). I’ve done this manually on Excel, how can this be done on Knime?
Sample 1: sample1
Sample 2: sample2

Hi Talatzubair,
With the dynamic number of colors it is not that easy in KNIME, I am afraid. I have attached a workflow that does what you want, but it uses a JavaSnippet node to achieve it and all the occurring colors have to be known beforehand. I hope it still helps!
Kind regards

colors.knwf (11.3 KB)

1 Like

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