topic missing values in attribute field (excel import) in Data Management Questions https://community.esri.com/t5/data-management-questions/missing-values-in-attribute-field-excel-import/m-p/643196#M36384 <HTML><HEAD></HEAD><BODY><SPAN>I have a variable, X, in an Arc file that I would like to copy as another variable, Z.&nbsp; The data is from a replication dataset using a raster grid.&nbsp; The original observations on X were a sample of grid squares, aprox. 300 out of 1,300 grid squares, taken from a survey.&nbsp; The original authors interpolated the remaining 1,000 observations using IDW.&nbsp; I am attempting to replicate their study, but using various methods of interpolation to show sensitivity in their findings.&nbsp; The problem is that in their replication data for X they include the interpolated values in the vector/column/variable with the observed survey values of variable X.&nbsp; I need to copy X and take out the interpolated values so that I may re-interpolate them using different methods.&nbsp; I have attempted to do this in two ways.&nbsp; First, I exported the data to excel, took the appropriate steps, then imported the data back into ArcGIS.&nbsp; However, Arc now only recognizes it as a String because the missing values are entered as "&lt;NULL&gt;".&nbsp; I have not found a way to correct this.&nbsp; Second, I generate a new variable in ArcCatalog, Z, and Arc fills in all the observations with zeros.&nbsp; Now, I cannot figure out how to copy and paste X into Z and then delete the interpolated values in Arc.&nbsp; I have found some posts on message boars that suggest using the "Attributes dialog box", but none of my variables (attributes?) show up in the box.&nbsp; Any suggestions?&nbsp; Thank you.</SPAN></BODY></HTML> Wed, 02 May 2012 19:48:38 GMT MarkShadden 2012-05-02T19:48:38Z missing values in attribute field (excel import) https://community.esri.com/t5/data-management-questions/missing-values-in-attribute-field-excel-import/m-p/643196#M36384 <HTML><HEAD></HEAD><BODY><SPAN>I have a variable, X, in an Arc file that I would like to copy as another variable, Z.&nbsp; The data is from a replication dataset using a raster grid.&nbsp; The original observations on X were a sample of grid squares, aprox. 300 out of 1,300 grid squares, taken from a survey.&nbsp; The original authors interpolated the remaining 1,000 observations using IDW.&nbsp; I am attempting to replicate their study, but using various methods of interpolation to show sensitivity in their findings.&nbsp; The problem is that in their replication data for X they include the interpolated values in the vector/column/variable with the observed survey values of variable X.&nbsp; I need to copy X and take out the interpolated values so that I may re-interpolate them using different methods.&nbsp; I have attempted to do this in two ways.&nbsp; First, I exported the data to excel, took the appropriate steps, then imported the data back into ArcGIS.&nbsp; However, Arc now only recognizes it as a String because the missing values are entered as "&lt;NULL&gt;".&nbsp; I have not found a way to correct this.&nbsp; Second, I generate a new variable in ArcCatalog, Z, and Arc fills in all the observations with zeros.&nbsp; Now, I cannot figure out how to copy and paste X into Z and then delete the interpolated values in Arc.&nbsp; I have found some posts on message boars that suggest using the "Attributes dialog box", but none of my variables (attributes?) show up in the box.&nbsp; Any suggestions?&nbsp; Thank you.</SPAN></BODY></HTML> Wed, 02 May 2012 19:48:38 GMT https://community.esri.com/t5/data-management-questions/missing-values-in-attribute-field-excel-import/m-p/643196#M36384 MarkShadden 2012-05-02T19:48:38Z