Clustering and writing back results into MySQl Database

ash1998

Hi

i am making Text clustering and i got 5 clusters with text.
So i want write back into the MYSQL Database to each. Im not sure where to connect the write database.

For example.
t1 is cluster 1
t2 is cluster 2
t3 is cluster 3

So i have a new Column in my table and every data should get a cluster.

Regards,
Ash

MartinLiebig

Hi,

just remove the cluster Visualizer. The blue output of clustering has all the information you wand.

Best,

Martin

ash1998

Hello, i have try that. and i got error. 

MartinLiebig

Hi,

try the other output port of clustering, that should work.

Best,

Martin

ash1998

Now it says too many column. I am running this in local repository. 

MartinLiebig

Hi,

likely you have hundreds or more columns from the Process Documents. Most databases have a max limit on it. I would use Select Attributes and only select id and cluster to go ahead.

Best,

Martin