Two nested tables in my decision tree model

[jennifer_chan via SQLMonster.com]

Hi all,

Does anyone know how to structure an "insert into" DMX query to train a
decision tree mining model with 2 nested tables? How can I append 2
DataTables? One nested table is predict_only and the other is input.

Any help is greatly appreciated. Thanks!

[Bogdan Crivat [MSFT]]

use 2 (or more) APPEND fragments in your SHAPE statement
Example:
INSERT INTO MyAssociationModel
([OrderNumber],[Models] (SKIP, [Model]),[Products] (SKIP, [Product])
)
SHAPE
{
OPENQUERY([Adventure Works DW],'SELECT OrderNumber
FROM vAssocSeqOrders ORDER BY OrderNumber')
}
APPEND
(
{OPENQUERY([Adventure Works DW],'SELECT OrderNumber, model FROM
dbo.vAssocSeqLineItems ORDER BY OrderNumber, Model')
}
RELATE OrderNumber to OrderNumber
) AS [Models],
(
{OPENQUERY([Adventure Works DW],'SELECT OrderNumber, Product FROM
dbo.vAssocSeqLineProducts ORDER BY OrderNumber, Product')
}
RELATE OrderNumber to OrderNumber
) AS [Products]


(You can replace the OPENQUERY statement with @paramTable if you use rowset
parameters)
--
--
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email directly to this alias. It is for newsgroup
purposes only.

thanks,
bogdan

Post by jennifer_chan via SQLMonster.com
Hi all,
Does anyone know how to structure an "insert into" DMX query to train a
decision tree mining model with 2 nested tables? How can I append 2
DataTables? One nested table is predict_only and the other is input.
Any help is greatly appreciated. Thanks!
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-data-mining/200804/1

[jennifer_chan via SQLMonster.com]

Thanks very much Bogdan. You've been very helpful once again!

Post by Bogdan Crivat [MSFT]
use 2 (or more) APPEND fragments in your SHAPE statement
INSERT INTO MyAssociationModel
([OrderNumber],[Models] (SKIP, [Model]),[Products] (SKIP, [Product])
)
SHAPE
{
OPENQUERY([Adventure Works DW],'SELECT OrderNumber
FROM vAssocSeqOrders ORDER BY OrderNumber')
}
APPEND
(
{OPENQUERY([Adventure Works DW],'SELECT OrderNumber, model FROM
dbo.vAssocSeqLineItems ORDER BY OrderNumber, Model')
}
RELATE OrderNumber to OrderNumber
) AS [Models],
(
{OPENQUERY([Adventure Works DW],'SELECT OrderNumber, Product FROM
dbo.vAssocSeqLineProducts ORDER BY OrderNumber, Product')
}
RELATE OrderNumber to OrderNumber
) AS [Products]
parameters)

Post by jennifer_chan via SQLMonster.com
Hi all,

[quoted text clipped - 3 lines]

Post by jennifer_chan via SQLMonster.com
Any help is greatly appreciated. Thanks!