Tuesday, July 31, 2012 9:16 PM
Hi,I have the data mining add in installed in excel. If I have table of data and I run the clustering tool on the table, say I specify I want the results to be 5 clustered groups, is there an easy way for me to tag the source table with a column which shows to which group the record was assigned?
Wednesday, August 01, 2012 12:46 AMAnswerer
This is done automatically when you click "Detect Categories" in the Analyze ribbon.
If you use "Data Mining" ribbon instead of Analyze ribbon, you can create segmentation model and then run Query wizard to get cluster names appended to the table
(as you go through wizard, when you are asked to choose output, add "*Cluster" to the list of outputs)
Tatyana Yakushev [PredixionSoftware.com]
- Marked As Answer by Tatyana YakushevEditor Wednesday, August 01, 2012 12:46 AM
Wednesday, August 01, 2012 11:06 AMThankyou - I hadn't configured my data as a table!