I am trying to merge two text columns (consisting of 2 digit and 3 digit numbers respectively) into one in ArcGIS 10.2.1 desktop version, but unable to do so. I have added a new field and kept it as text. On using arc toolbox > data management tools > calculate field, I am trying to merge the two columns into the newly created column.
Example:
I have the following two columns in the shapefile - Code1 (text, 10) and Code 2 (text, 10). I want to concatenate the values in these two columns in a new data field Key (text,11) that I have already created.
Code1 Code2 Key
015 21 21015
647 19 19647
213 05 05213
When I try to use field calculator I get the error no records within table
. See below:
!RMSCODE2!+!RMSCODE1!