Float Comparison - Decimals

JeremyL

I would like to define how many decimals out to compare floats via truncation, rounding, or even tolerance percent. E.g. an option to say "don't compare floats after the nth decimal" would be great! Right now, I'm trying to compare two 3 million record views that have 100 float columns of which I don't care past the 2nd decimal and SQL Data Compare has identified 86k records different mostly due to differences to some obscure decimal. I am unable to identify the differences I actually care about.

mattchandler

Hi Jeremy,

I'm afraid it isn't possible to do this in Data Compare at the moment. If this would be a valuable feature to you could I suggest you leave a suggestion on uservoice. We use these requests to help prioritize upcoming work.