Problem in Deduping
Moderators: chulett, rschirm, roy
This is all fine and dandy. However, the answer is clear - there cannot repeat can not be duplicate key values in a hashed file. Period. End of story.
In spite of what has been posted as to how the records may look the same to the naked eye, there must be differences between them. Period. End of story. Sensing a pattern here?
Rather than assuming there 'can not be extra spaces' or things of that ilk, the OP needs to look much closer at their source data and the design of the hashed file. Something in there is not at they are expecting and is causing these apparent duplicates. This is not something we can solve for them, other than to point them in the right direction.
In spite of what has been posted as to how the records may look the same to the naked eye, there must be differences between them. Period. End of story. Sensing a pattern here?
Rather than assuming there 'can not be extra spaces' or things of that ilk, the OP needs to look much closer at their source data and the design of the hashed file. Something in there is not at they are expecting and is causing these apparent duplicates. This is not something we can solve for them, other than to point them in the right direction.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers