|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | Combining UDMs with different selections | |
| dvlander 7/20/2010 6:56:54 PM | I remember from prior posts that it is possible to see how results fare if you have a horse present on 2 different UDMs within the same race. However, I wanted to ask if it's possible to see combinations of a UDM you have devised when elements of another UDM involving different horses is present. For example, say I have a UDM that generally points out longer priced horses and I would like to see how that UDM performs when another UDM highlights what would be considered very strong favorites or maybe another UDM that highlights very weak favorites. I'm sure you see what I'm after. Is it possible without having to have Jeff's programming ability? Thanks, Dale
| |
| Charlie James 7/20/2010 8:20:35 PM | I'm no programmer and I do it all the time in the data window. Playlistfile mode: 1. Click menu, click exports, click quick index file create new. 2. Run udm #1 through the data window creating a new quick index file as you go. 3. Run udm #2 through the data window. Instead of the normal pl_profile.txt, click the quick index file created above. The results that come back are an 'intersection' of the two udms. ~Edited by: Charlie James on: 7/20/2010 at: 8:20:35 PM~
| |
| jeff 7/21/2010 2:17:49 AM | Combining Two or More Separate UDMs in SQL Mode: To combine sql expressions from two distinct UDMs and see results in the Data Window for starters selected by both UDMs, use the following strategy: SELECT * FROM STARTERHISTORY WHERE (paste all of the factor conditonals from the UDM Definition of the first UDM inside of this first set of parenthesis characters) AND (paste all of the factor conditionals from the second UDM Definition inside of this second set of parenthesis characters) What if you want to create an OR conditional between the two UDMs... and see Data Window results for starters selected by either UDM? Just replace the word AND used above to separate the two UDM Definitions with the word OR. -jp . ~Edited by: jeff on: 7/21/2010 at: 2:17:49 AM~
| |
| dvlander 7/21/2010 9:40:22 AM | Appreciate the helpful responses. Thanks, Dale
| |
| ryesteve 7/21/2010 9:46:49 AM | Those answers explain how to get tabs on horse that qualify (or don't) under multiple UDMs. But trying to do what you're trying to do (multiple horses) is more challenging, because each record in JCapper is one horse... there's no way to directly query factors relating to multiple horses from the same race. I believe you may be able to do what you want in SQL mode, but it would be a two step process. Jeff, please confirm whether or not the SQL implementation in JCapper would allow for this. THe first step would be to run your weak favorite UDM, but don't save all the fields... you only want to save date, track and race. Next, run the UDM you're interested in, but along with specifying the UDM criteria, run it as a join with the first file, so that you only get races that are UDM hits from the subset of races where there was a hit against the first UDM.
| |
| jeff 7/21/2010 7:37:14 PM | --quote: However, I wanted to ask if it's possible to see combinations of a UDM you have devised when elements of another UDM involving different horses is present. --end quote-- Ahh... I see now that I misread the original question. I took it to be: "How do I handle multiple UDMs converging on the same horse?" It appears the question instead was: "How do I handle/track the effect of different UDMs converging on different horses within the same race?" Right now I do not believe there is an automated way to do this from inside of JCapper. My strategy would be to write a set of queries for each UDM that, in addition to querying the JCapper database, also inserted data resulting from the UDM queries into table(s) residing in an Access or other db file outside of JCapper. And from there create a second set of queries (or reports)(an Access report would be able to do this) to report desired results on a per race basis instead of on a per horse basis. My apologies for misreading the original question. -jp . ~Edited by: jeff on: 7/21/2010 at: 7:37:14 PM~
| |
| dvlander 7/22/2010 4:09:36 PM | No problem Jeff. I had a hunch when I ran the process through my mind that it probably was not achievable through SQL with simple instructions. I completed an entire quarter of examining race card by race card and at least thought I'd ask to see if there is a better way. I appreciate your guidance as always. Dale
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |