Add cluster groupings to the source table in excel DM add in?

Question

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?

Thanks

Answer 1

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]

Answer 2

Thankyou - I hadn't configured my data as a table!