Data Mining

Download Free Data Mining Source Code In C/C++, C#, Visual Basic, Visual Basic.NET, Java,
and other programming languages
Welcome to Data Mining Sign in | Join | Help
in Search

Data Mining Source Code Newsletter

Business Analyst Training
Live, Online, Video Courses
Instructor-Led + Hands-On
BusinessAnalystBootCamp.Com

SQL + Database Training
Live, Online, Video Classes
Instructor-Led + Hands-On
SQLBootCamp.Com

Software Developer Training
Live, Online, Video Courses
Instructor-Led + Hands-On
SoftwareDevelperBootCamp.Com

IT CAREER COACH
Hands-On Experience Coaching
IT Skills Training
IT-Career-Coach.NET

IT Professional Newsletter
"Free" IT Career Success Tips
How To Accelerate Your Career
IT Career Newsletter

Ask IT Career Questions
"ASK" A Burning IT Career
Question Or Get Answers
Ask A Burning IT Question Now!

Announcing The Data Mining Source Code Newsletter!

Subscribe By Email | Subscribe By RSS Feed

CASE or SWITCH

Last post 02-03-2009, 14:13 by TimManns. 1 replies.
Sort Posts: Previous Next
  •  02-03-2009, 4:59 8635

    CASE or SWITCH

    I want to perform custom bining . I have 9 predefined bins and I want to convert it to 9 nominal values with names. How I can to write CASE/SWITCH statement in DERIVE mode . Or nested if ?
  •  02-03-2009, 14:13 8638 in reply to 8635

    Re: CASE or SWITCH

    set-to-flag node will 'flip or transpose' your single column/field bin with 9 category values into 9 fields, each with a nominal yes/no default value.  You can instead use 1/0 or after the yes/no nominal values use a filler node to replace the 'yes' with any value you chose, including a value of another field.  If you replace one value with another make sure they are noth the same data type (cannot replace 0 or 1 with text)

    Cheers

    Tim
    http://timmanns.blogspot.com/

Announcing The Data Mining Source Code Newsletter!

Subscribe By Email | Subscribe By RSS Feed