Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- Drive Type

Home Register
Log In
By Drive Type
crestwood1972
7/30/2012
1:39:49 AM
How can I exclude Drive Type = 1?

Love the 0 and love the 2. Hate the 1.

Using the playlist in constructing my UDM.

Reply
jeff
7/31/2012
4:09:28 AM
First, Drive Type values visible in the Data Window:

0 - none
1 - DriveType 1
2 - DriveType 2




Playlist File Mode
You'll find DriveType in the factors drop downs of both the Data Window and UDM Wizard. DriveType is also "grabbable" as a factor (numeric value and translate behavior only) for use in UserFactors and UPR within the IVTable Wizard. (JCapper Platinum only)

If you like the 0, like the 2, but hate the 1 - and want to exclude Drive Type 1 from a UDM, and you are operating in playlist file mode, your best option is to use multiple UDMs.

Take a UDM that has everything you want it to have and Clone it so that you have 2 copies of the same UDM.

From there, use the Modify Screen in the UDM Wizard to give the original UDM a min and max value for Drive Type of 0 and hit the save button.

Next, bring up the Clone of the UDM in the Modify Screen of the UDM Wizard, give that UDM a min and max value for Drive Type of 2 and save.

At this point, you have the original version of the UDM that likes drive type=0.

You also have a second version of the UDM - the clone - that likes drive type=2.

Drive types 0 and 2 will be flagged on your reports by the original UDM and the clone respectively.

But drive type 1 is avoided - because you don't have a version of the UDM that likes the 1.

Make sense?




Drive Type - SQL Mode UDMs
Its easier to hate the 1 using sql mode because you can do it using a single UDM.

To hate the 1, add a line like the following to the sql expression driving the UDM:

AND DRIVETYPE <> 1


That's it!


-jp

.




Reply
Reply

Copyright © 2018 JCapper Software              back to the JCapper Message Board              www.JCapper.com