Home Forums Data Warehousing Data Transformation Services (DTS) regression to classification binary RE: regression to classification binary

  • August 7, 2012 at 2:12 pm

    #1522835

    mick19790 (8/7/2012)

    Can anyone assist me on how i go about arranging data that i used as continous input,to data that goes through pair combos for binary output.ie

    out

    3 5 9 19 11

    4 6 7 12 23

    3 3 4 6 7 2

    to something similar

    3 5 9 19 1

    4 6 7 12 0 etc

    Thanks

    huh?

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/