topic Re: Joining values of two fields in Python Questions https://community.esri.com/t5/python-questions/re-joining-values-of-two-fields/m-p/322791#M25163 <HTML><HEAD></HEAD><BODY><P>If you are calculating into a TEXT field, and on of the fields is an integer, try the following:</P><P></P><P>str(!Corridor!) + str(!RM!)</P><P></P><P>If not, let me know what type of fields Corridor, RM, and the field you are calculating to are.</P></BODY></HTML> Fri, 09 Oct 2015 15:33:05 GMT JakeSkinner 2015-10-09T15:33:05Z Re: Joining values of two fields https://community.esri.com/t5/python-questions/re-joining-values-of-two-fields/m-p/322788#M25160 <HTML><HEAD></HEAD><BODY><P>Thanks that worked great..&nbsp; I know I should post this in a new thread but was hoping for a quick answer.&nbsp; I'm trying to join 2 fields.&nbsp; the corridor field and the RM field.&nbsp; I was thinking it would look something like this but cant seem to figure it out.&nbsp; .join(!Corridor! + !RM!)</P></BODY></HTML> Fri, 09 Oct 2015 14:05:02 GMT https://community.esri.com/t5/python-questions/re-joining-values-of-two-fields/m-p/322788#M25160 TerryGustafson 2015-10-09T14:05:02Z Re: Joining values of two fields https://community.esri.com/t5/python-questions/re-joining-values-of-two-fields/m-p/322789#M25161 <HTML><HEAD></HEAD><BODY><P>You can perform this in the field calculator.&nbsp; Make sure you have 'Python' at the top of the field calculator checked and then the syntax would be:</P><P></P><P>!Corridor! + !RM!</P></BODY></HTML> Fri, 09 Oct 2015 14:23:53 GMT https://community.esri.com/t5/python-questions/re-joining-values-of-two-fields/m-p/322789#M25161 JakeSkinner 2015-10-09T14:23:53Z Re: Joining values of two fields https://community.esri.com/t5/python-questions/re-joining-values-of-two-fields/m-p/322790#M25162 <HTML><HEAD></HEAD><BODY><P>I tried that and it won’t work.. Not sure if it has something to do with it being a text field..</P></BODY></HTML> Fri, 09 Oct 2015 15:07:17 GMT https://community.esri.com/t5/python-questions/re-joining-values-of-two-fields/m-p/322790#M25162 TerryGustafson 2015-10-09T15:07:17Z Re: Joining values of two fields https://community.esri.com/t5/python-questions/re-joining-values-of-two-fields/m-p/322791#M25163 <HTML><HEAD></HEAD><BODY><P>If you are calculating into a TEXT field, and on of the fields is an integer, try the following:</P><P></P><P>str(!Corridor!) + str(!RM!)</P><P></P><P>If not, let me know what type of fields Corridor, RM, and the field you are calculating to are.</P></BODY></HTML> Fri, 09 Oct 2015 15:33:05 GMT https://community.esri.com/t5/python-questions/re-joining-values-of-two-fields/m-p/322791#M25163 JakeSkinner 2015-10-09T15:33:05Z Re: Joining values of two fields https://community.esri.com/t5/python-questions/re-joining-values-of-two-fields/m-p/322792#M25164 <HTML><HEAD></HEAD><BODY><P>Or try this tip</P><P><IMG __jive_id="130457" alt="Field_calculator_tip_01.png" class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/130457_Field_calculator_tip_01.png" style="width: 400px; height: 200px;" /></P></BODY></HTML> Fri, 09 Oct 2015 15:44:21 GMT https://community.esri.com/t5/python-questions/re-joining-values-of-two-fields/m-p/322792#M25164 DanPatterson_Retired 2015-10-09T15:44:21Z Re: Joining values of two fields https://community.esri.com/t5/python-questions/re-joining-values-of-two-fields/m-p/322793#M25165 <HTML><HEAD></HEAD><BODY><P>That worked but it adds a .0 to the end of the RM..&nbsp; I created the RM field as a short with 0 decimal places.&nbsp; So it returned C000001E156.0.&nbsp; The precision is set to 4</P></BODY></HTML> Fri, 09 Oct 2015 15:54:16 GMT https://community.esri.com/t5/python-questions/re-joining-values-of-two-fields/m-p/322793#M25165 TerryGustafson 2015-10-09T15:54:16Z Re: Joining values of two fields https://community.esri.com/t5/python-questions/re-joining-values-of-two-fields/m-p/322794#M25166 <HTML><HEAD></HEAD><BODY><P>I got it..&nbsp; Thanks for your help./.&nbsp; Have a good weekend..</P></BODY></HTML> Fri, 09 Oct 2015 19:09:42 GMT https://community.esri.com/t5/python-questions/re-joining-values-of-two-fields/m-p/322794#M25166 TerryGustafson 2015-10-09T19:09:42Z Re: Joining values of two fields https://community.esri.com/t5/python-questions/re-joining-values-of-two-fields/m-p/322795#M25167 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD><SPAN style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">I'm trying to join 2 fields.&nbsp; the corridor field and the RM field. Calculate Field (PYTHON) str(!CORRIDOR!) + str(!RM!) <SPAN style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;"> worked but it adds a .0 to the end of the RM..&nbsp; I created the RM field as a short with 0 decimal places.&nbsp; So it returned C000001E156.0.&nbsp; The precision is set to 4</SPAN></SPAN></TD></TR></TBODY></TABLE></BLOCKQUOTE><P>Try this Calculate Field syntax</P><P></P><PRE class="lia-code-sample line-numbers language-none">arcpy.CalculateField_management(tbl, field, &nbsp;&nbsp;&nbsp; "{}{:.0f}".format(!CORRIDOR!, !RM!), "", "PYTHON_9.3")</PRE></BODY></HTML> Sat, 11 Dec 2021 15:20:23 GMT https://community.esri.com/t5/python-questions/re-joining-values-of-two-fields/m-p/322795#M25167 curtvprice 2021-12-11T15:20:23Z