On Thursday, February 15, 2018 at 10:44:46 AM UTC-8, Anthony wrote: > > Both methods work with my main test data (the source of 111 X and 10 Y), >> yielding 9 runs that match both. The alias method, however, let a >> duplicate row sneak in. I need to test more pairs, but I think you >> (Anthony) solved my problem. >> > > If the alias method is producing duplicates, I'm guessing the run in > question has the same waypoint repeated more than once. Just set > distinct=True to remove the duplicates. >
Ah, I'm using "contains", so (from memory) I have a waypoint of "Cabot", and then a waypoint of "I-5@Cabot", both of which match. Using "distinct" is easier than tightening the condition, and I don't think runs with just " I-5@Cabot" will be a problem, but I might have some other waypoints where I could trick myself. > >> >> BTW, can one do a groupby inappadmin/select? >> > > I don't think so. > > I suspected that. > Anthony > /dps "thanks again" -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
