I want to partition on state.
I thought I'd use lists, but if there is a miss on an invalid state, it throws the record away.
I was trying to do it on the hash(ascii(state)) to at list break it down by 1st char, but it refused to let me use that.
Any ideas?