DSXchange

I am loading data from a comma-delimited file to a hash file, so I can do quick look-ups on it. The problem I'm having is that some of the data gets reformated when I move it over, for no apparent reason.

Example: I have account numbers that need to be 4 digits. Some of them have leading zeroes, though. 0001, 0002, 0003, etc. When I move the data to the has file, it drops the zeroes. I do not want it to drop the zeroes, but can't see how to stop that from happening.

Any info/help would be greatly appreciated. Thanks!

Eric, declare that column as VARCHAR in the source and hashed file and it won't strip out the leading zeroes.

ArndW wrote:Eric, declare that column as VARCHAR in the source and hashed file and it won't strip out the leading zeroes. ...

Thanks! I will give that a shot!