none
DMX Help

    คำถาม

  • I need some help with DMX, I have req where I need to predict multiple events from a mining model, I started working on getting two predictions, I am geeting the result back but not the format i want

    SELECT FLATTENED [Name],

    PredictTimeSeries([aging],25) AS r,

    PredictTimeSeries([Ext], 25) AS t

    FROM [Symm]

    Name TIME Aging TIME Ext
    R03 3/5/2012 0:00 -5.06E+27    
    R03 3/6/2012 0:00 -1.67E+31    
    R03     3/5/2012 0:00 51858.10218
    R03     3/6/2012 0:00 6901.215308
             
             
    Name TIME Aging TIME Ext
    R03 3/5/2012 0:00 -5.06E+27 3/5/2012 0:00 51858.10218
    R03 3/6/2012 0:00 -1.67E+31 3/6/2012 0:00 6901.215308

    first dataset is what I am getting back when I run the above query, I want my data to be like the second result set.

    I have to do the prediction for several columns in the same way.

    Thanks in Advance.


    • แก้ไขโดย ramarama 15 กุมภาพันธ์ 2555 15:27
    15 กุมภาพันธ์ 2555 15:25

คำตอบ