topic AGOL JOIN command: do match field data types have to match? in ArcGIS Online Questions

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

JayLarsen — Thu, 13 Apr 2023 17:17:28 GMT

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.

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

David_McRitchie — Tue, 18 Apr 2023 15:58:50 GMT

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.

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

JayLarsen — Tue, 18 Apr 2023 21:59:48 GMT

Thanks!

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