Amount match but not readable by Join Tool

Question

Hi there,

I have a problem, I have an amount which is match but when I joined the two files, the join tool doesn't read as match. My amount is 239,385.74. Can you please tell me the reason why. Please tell possible solutions to solve this dilemma.

Thanks,

Mar

mceleavey · Accepted Answer

Hi @KamenRider ,

You should avoid joining on numbers, but the problem is most likely because of the precision. One number will have more decimal places and is simply displayed incorrectly, or because you have trailing spaces etc.

Can you share the data and show what you're trying to do and we can help.

M.