Amount match but not readable by Join Tool

[KamenRider]

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 solution]

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.

[KamenRider]

Hi @mceleavey ,

Yeah you're right. Maybe because I'm using numbers and this is the reason why there are no match to be found. What I did is change the data type in the select tool to string of both fields in different file and it works. Matches are to be found.

Thanks for your ideas.

Mar