if/then table joiner

[chiabell]

Good morning!
i am working on a hybrid clustering, first step is k-means with an high K and then hierarchical to pick the correct number of clusters.
i am using the 2nd output of k-means node (cluster means) as input for the hierarchical node, but now i need to relate the original table/units to the cluster i found with AHC.
i understand that the connection is the k-means cluster table but how can i add a column to the original table with the correspondence of each unit to the AHC clusters?

[aworker]

Good morning @chiabell !

Nice project ! Would it be possible for you to upload here the piece of workflow showed in your snapshot with dummy data to help you from there ?

Thanks & regards,

Ael

[chiabell]

sorry i don’t have dummy data! but here’s the relation i need to find, i hope it’s clear enough! from left to right
unit to clusters using k-means
k-means cluster means
k-means cluster as units to AHC clusters

[aworker]

No problem @chiabell

If I correctly understood, the following workflow should do the job. Otherwise please let me know:

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

[chiabell]

thank you SO MUCH! that’s exactly what i needed!
KNIME has a great community!

thanks again, have a good day
Chiara

[aworker]

Thanks Chiara for your kind message and for validating the solution !

It was really a pleasure to help.

Enjoy your day too !

Ael