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

Automated Data Preparation (ADP) looses typeless fields

Last post 01-18-2010, 15:06 by kkrobinson. 3 replies.
Sort Posts: Previous Next
  •  01-14-2010, 6:35 9557

    Automated Data Preparation (ADP) looses typeless fields

    Hi, This is hopefully a simple question:  I'm z-scoring my data using the automated data preparation (ADP) node and I set my ID field to typeless since I don't want it z-scored.  But the node is removing that field rather than passing it on to the next node, and I need it to later on score our subscribers. 

     How can I pass it on to the next node?

     

    Thanks in advance.

    Keith

  •  01-18-2010, 7:46 9568 in reply to 9557

    Re: Automated Data Preparation (ADP) looses typeless fields

    Keith,

    In the "Settings" tab of the ADP node, select "Field Settings" in the left panel under Settings.

    You will see in the middle of the right panel:  "How to handle fields that are excluded from modeling:"

    The default setting is to "Filter out unused fields" so you merely need to select the other radio button:

    "Set the direction of unused fields to 'None'"

    Steve

    P.S.  a workaround would be to perform a (keyless) merge by record order but that shouldn't be necessary.

  •  01-18-2010, 8:03 9570 in reply to 9557

    Re: Automated Data Preparation (ADP) looses typeless fields

    Hi there- Please note, that if your ID var is read as typless upstream from ADP, (to the best of my knowledge) it won't be processed by the ADP node. To fix this either set the ID to scale and set it to 'in'. Or if it's string and it needs to be read as nominal, then first r-click anywhere on the canvas, go to stream properties and deselect maximum set size. Then re-read the data with the type node, and set the ID var to 'in' as well. That should do it! Then follow the other instructions you received on this site.

     

    Best,

    James E. Parry

  •  01-18-2010, 15:06 9572 in reply to 9568

    Re: Automated Data Preparation (ADP) looses typeless fields

    Thanks Steve!  That worked.

     

    Keith

Announcing The Data Mining Source Code Newsletter!

Subscribe By Email | Subscribe By RSS Feed