The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

Clustering and writing back results into MySQl Database

ash1998
ash1998 Member Posts: 5 image Learner I
in Help
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

Tagged:

Answers

  • MartinLiebig
    MartinLiebig Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,533 image RM Data Scientist
    Hi,
    just remove the cluster Visualizer. The blue output of clustering has all the information you wand.

    Best,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • ash1998
    ash1998 Member Posts: 5 image Learner I
    Hello, i have try that. and i got error. 


  • MartinLiebig
    MartinLiebig Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,533 image RM Data Scientist
    Hi,
    try the other output port of clustering, that should work.

    Best,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • ash1998
    ash1998 Member Posts: 5 image Learner I
    Now it says too many column. I am running this in local repository. 
  • MartinLiebig
    MartinLiebig Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,533 image RM Data Scientist
    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
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany

Categories