Home Forums Data Warehousing Data Mining Simple (I think!) Clustering Question (Please help!) RE: Simple (I think!) Clustering Question (Please help!)

  • I think the issue is that you've set ID_NUM as a key. They aren't unique so the data mining tool is getting confused.

    You don't need to change the data to "horizontal", how you have it is fine.

    You will need a surrogate key on the table, so that each row of ID_NUM, TECK_ID and TECK_VALUE is a unique element. Just insert a column and populate with an IDENTITY or row number.

    You can then get the model to data mine on the TECK VALUE based on either TECK ID or ID_NUM or a combination of both.