Help with Cluster Assignment

[aworker]

Hi @Paria_akhdari & welcome to the KNIME forum,

Complementary to @ScottF’s posted workflows, maybe the following workflows are of help to answer your question too:

1st workflow:

if/then table joiner

No problem @chiabell If I correctly understood, the following workflow should do the job. Otherwise please let me know: [20210616 Pikairos K-Means followed by Hierarchical Cluster Asigner] It integrates two options, 1st one where in the end you have for every row the normalized columns, and the 2nd one (below) which recovers the initial column values before normalization: 20210616 Pikairos K-Means followed by Hierarchical Cluster Asigner.knwf (139.4 KB) Hope this helps. Best, Ael

K-Means followed by Hierarchical Clustering – pikairos

2nd workflow:

Handling missing value in clustered data

Thanks again @Daniel_Weikert ! I very much appreciate it ! … and it motivated me to eventually put in place a possible solution [image] 20211201 Pikairos Handling missing value in clustered data.knwf (687.0 KB) @m1k here you have a workflow which should answer your second question. I did not use a set with missing values as reference but if you replace the data set used here by yours with missing values, it should do the job. Otherwise, let us know and we will amend it. H…

20211021 Pikairos Scoring new clusters with existing cluster centers – pikairos

Best
Ael