topic Value from a table into a map algebra expression? in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/value-from-a-table-into-a-map-algebra-expression/m-p/259788#M8911 <HTML><HEAD></HEAD><BODY><SPAN>How do you incorporate a value from a table into a map algebra expression?</SPAN><BR /><SPAN>My goal is to subtract the 'background temperature' from all cells in a raster.&nbsp; I have defined the 'background temp' as the average value of the cells in the lowest quartile of my raster.&nbsp; I have used 'slice' to identify which cells are in the lowest quartile, then I used 'Zonal Statistics as table' to get the average value of cells in that lowest quartile.&nbsp; So now, I want to pull the mean from the Zonal stats table where "Value"=1.&nbsp; I feel like a lookup function should be able to work for this, but it seems to be just for rasters.</SPAN><BR /><BR /><SPAN>Is there any way to use map algebra to pull a coefficient value out of a table so that it can be called for further calculations?</SPAN><BR /><BR /><SPAN>Thanks for any help you can provide,</SPAN><BR /><SPAN>Aariel</SPAN></BODY></HTML> Sat, 05 Oct 2013 20:17:39 GMT aarielRocha 2013-10-05T20:17:39Z Value from a table into a map algebra expression? https://community.esri.com/t5/geoprocessing-questions/value-from-a-table-into-a-map-algebra-expression/m-p/259788#M8911 <HTML><HEAD></HEAD><BODY><SPAN>How do you incorporate a value from a table into a map algebra expression?</SPAN><BR /><SPAN>My goal is to subtract the 'background temperature' from all cells in a raster.&nbsp; I have defined the 'background temp' as the average value of the cells in the lowest quartile of my raster.&nbsp; I have used 'slice' to identify which cells are in the lowest quartile, then I used 'Zonal Statistics as table' to get the average value of cells in that lowest quartile.&nbsp; So now, I want to pull the mean from the Zonal stats table where "Value"=1.&nbsp; I feel like a lookup function should be able to work for this, but it seems to be just for rasters.</SPAN><BR /><BR /><SPAN>Is there any way to use map algebra to pull a coefficient value out of a table so that it can be called for further calculations?</SPAN><BR /><BR /><SPAN>Thanks for any help you can provide,</SPAN><BR /><SPAN>Aariel</SPAN></BODY></HTML> Sat, 05 Oct 2013 20:17:39 GMT https://community.esri.com/t5/geoprocessing-questions/value-from-a-table-into-a-map-algebra-expression/m-p/259788#M8911 aarielRocha 2013-10-05T20:17:39Z Re: Value from a table into a map algebra expression? https://community.esri.com/t5/geoprocessing-questions/value-from-a-table-into-a-map-algebra-expression/m-p/259789#M8912 <HTML><HEAD></HEAD><BODY><SPAN>Found my own answer.&nbsp; It seems there are additional model builder only tools that you can access from within the Model window.&nbsp;&nbsp; Insert &gt; Model Only Tools &gt; Get Field Value.</SPAN><BR /><SPAN>Such an easy answer!&nbsp; i wish it didn't take me hours and hours and hours to figure it out.&nbsp; I wonder why there are tools that are not accessible from the toolbox.</SPAN></BODY></HTML> Wed, 16 Oct 2013 16:56:26 GMT https://community.esri.com/t5/geoprocessing-questions/value-from-a-table-into-a-map-algebra-expression/m-p/259789#M8912 aarielRocha 2013-10-16T16:56:26Z