I was attempting to run a Sequence Clustering DM in Excel and I tried to get around the need for a nested table by flattening my normalized Sales Order and Sales Order Line Item into a single table through a query.
However, when I go to create the Mining Structure in Excel, there is no option for setting the Key Sequence. If I go try to add a Mining Model to a mining Structure, Sequence Clustering is an option but I cannot proceed unless I set the Key Sequence when
I am building the Mining Structure.
Does MS Excel DM support Sequence Clustering analysis? Or is there a workaround within Excel?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.