AGOL JOIN command: do match field data types have to match?

[JayLarsen]

I use the JOIN command quite a bit to add data to ZIP layers.  So, I do a JOIN on the ZIP field.  Does JOIN convert types to match?  E.g. if I JOIN on ZIP that is integer and the other layer ZIP is a string (as it should be) will the JOIN work?

I got this question from a colleague and I simply don't know.  I haven't run into it.

The Living Atlas ZIP layer the ZIP filed as a string, and I usually type mine as string when upload data.

Has anybody done this experiment? Is there a known spec on the JOIN command, e.g. would integer = 2 match a float = 2?

I'd love to see a doc or answer to this, just in case...

Thank You.

[David_McRitchie · Accepted solution]

I gave this a quick test and the field types will need to be the same.

If you have a copy of the layer then I would recommend creating a new field with the matching data type, then use the Field Calculator to transfer the values from the old field.

[JayLarsen]

Thanks!

I can't believe I was just lucky for all of these years.