https://community.esri.com/t5/arcmap-questions/when-i-add-a-new-field-i-select-quot-short-integer/m-p/1163672#M3659 <P>Hi Amanda,</P><P>I'm using 10.6.1. I was able to find a solution which I've posted above. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Tue, 12 Apr 2022 20:46:50 GMT EllieHakariAK 2022-04-12T20:46:50Z https://community.esri.com/t5/arcmap-questions/when-i-add-a-new-field-i-select-quot-short-integer/m-p/1163632#M3657 <P><STRONG>UPDATE: I was able to find a work-around. I've put it at the bottom of this post for anyone who experiences this same issue.</STRONG></P><P>&nbsp;</P><P>Hello everyone!</P><P>I'm attempting to load a dataset (D1) into another dataset (D2) and need all the field types to match. I am attempting to switch several of the fields in D1 from "Long Integer" to "Short Integer" to match D2's "Short" fields. However, when I go to "Add Field" in D1 and select "Short Integer", the resulting field defaults to "Long Integer". I have no idea why this is happening:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="NewField1.PNG" style="width: 290px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/38712i077745A7BD5FF291/image-size/medium?v=v2&amp;px=400" role="button" title="NewField1.PNG" alt="NewField1.PNG" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="NewField2.PNG" style="width: 362px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/38713i6966993DA3FCB532/image-size/medium?v=v2&amp;px=400" role="button" title="NewField2.PNG" alt="NewField2.PNG" /></span></P><P>This change in types is happening directly after creating the field, and I haven't even begun loading new data into it with the Field Calculator. Does anyone know why this is happening? It's frustrating because I performed about 10 of these conversions before noticing this issue. Any advice would be greatly appreciated!</P><P>&nbsp;</P><P><STRONG>SOLUTION:</STRONG></P><P>When creating the field, if the "Precision" value is 5 or more, the field will default to "Long". For me, the default precision value when selecting "Short" was 0, but I had to change it to 4 to get the "Short" type to stay. Hope this helps someone!</P> Tue, 12 Apr 2022 20:45:59 GMT https://community.esri.com/t5/arcmap-questions/when-i-add-a-new-field-i-select-quot-short-integer/m-p/1163632#M3657 EllieHakariAK 2022-04-12T20:45:59Z https://community.esri.com/t5/arcmap-questions/when-i-add-a-new-field-i-select-quot-short-integer/m-p/1163671#M3658 <P>What version of ArcMap?</P> Tue, 12 Apr 2022 20:43:58 GMT https://community.esri.com/t5/arcmap-questions/when-i-add-a-new-field-i-select-quot-short-integer/m-p/1163671#M3658 ABishop 2022-04-12T20:43:58Z https://community.esri.com/t5/arcmap-questions/when-i-add-a-new-field-i-select-quot-short-integer/m-p/1163672#M3659 <P>Hi Amanda,</P><P>I'm using 10.6.1. I was able to find a solution which I've posted above. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Tue, 12 Apr 2022 20:46:50 GMT https://community.esri.com/t5/arcmap-questions/when-i-add-a-new-field-i-select-quot-short-integer/m-p/1163672#M3659 EllieHakariAK 2022-04-12T20:46:50Z https://community.esri.com/t5/arcmap-questions/when-i-add-a-new-field-i-select-quot-short-integer/m-p/1163674#M3660 <P><A href="https://desktop.arcgis.com/en/arcmap/latest/manage-data/tables/design-data-types-in-the-dbms.htm" target="_blank">Data types in the DBMS—ArcMap | Documentation (arcgis.com)</A></P><P>depends on the destination table type.&nbsp; sometimes field types can be remapped to the closest available type.</P><P>&nbsp;</P> Tue, 12 Apr 2022 20:48:12 GMT https://community.esri.com/t5/arcmap-questions/when-i-add-a-new-field-i-select-quot-short-integer/m-p/1163674#M3660 DanPatterson 2022-04-12T20:48:12Z