none
DMX Help

    Pergunta

  • 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.


    • Editado ramarama quarta-feira, 15 de fevereiro de 2012 15:27
    quarta-feira, 15 de fevereiro de 2012 15:25

Respostas

  • Hi rama,

    As far as i know, there is no straightforward way to format the 2 prediction columns in the same way. If you have to do that, you could consider loading the prediction result into tables of relational database, then join them into one table holding these columns in the same way.

    Hope this helpfully,

    Regards,
    Jerry

    quarta-feira, 22 de fevereiro de 2012 01:46