To select the "best" record when I have dupes, I have to compare the output of a Join tool with a DB that has 200+ fields, and thus the output will have 400+ fields, the 200 plus another 200 labeled "Right_Field1" through "Right_Field200".
After I mark the best record by comparing values between "Important Field 39" and "Right_Important Field 39", and saying the best side is the left or the right side, I Filter based on the Best Side marker. Then I pass the T and the F outputs through their own Selects.
One will suppress all the left fields, the other will suppress all the Right_ fields, to pare the record back to the original 200.
"De-select all" isn't helpful. I need to de-select exactly half.
I could set up a Dynamic Select with some work, but I am hoping there is some keyboard shortcut that lets you highlight 200 consecutive fields in the Select tool and click "uncheck".....
Thanks!
