topic Setting conditions to the attribute table! in Data Management Questions https://community.esri.com/t5/data-management-questions/setting-conditions-to-the-attribute-table/m-p/219823#M12520 <HTML><HEAD></HEAD><BODY><SPAN>Ok, please bare with me...I do not have english as my native language!</SPAN><BR /><BR /><SPAN>The question!</SPAN><BR /><BR /><SPAN>I need to figure out how to import data to a attribute table with some conditions, meaning....example, I have let say 50 points made in a shapefile layer, I would like to import data from a excel sheet to them!</SPAN><BR /><BR /><SPAN>Ok, so to the part I do not understand, how do you make it happen IF the data from the imported excel sheet NEEDS to dictate the color of the point! Lets say IF the data have the number 5 or less..the point turns red, if the data have the 6 or more the point turns yellow....and so on! Also it needs to be different conditions to each point!</SPAN><BR /><BR /><SPAN>SO, again, I put 50/500/5000 points to a map.....import excel data/information to ArcMap and then JOIN the tables, then by "magic" depending on the values in the excelsheet my points will change color depending what condition I will give it?!?</SPAN><BR /><BR /><SPAN>Hope somebody understood my questions and can help me....</SPAN><BR /><BR /><SPAN>Regards from cold Sweden</SPAN><BR /><BR /><SPAN>//Mattias</SPAN></BODY></HTML> Wed, 16 Jan 2013 17:30:27 GMT MattiasTancred 2013-01-16T17:30:27Z Setting conditions to the attribute table! https://community.esri.com/t5/data-management-questions/setting-conditions-to-the-attribute-table/m-p/219823#M12520 <HTML><HEAD></HEAD><BODY><SPAN>Ok, please bare with me...I do not have english as my native language!</SPAN><BR /><BR /><SPAN>The question!</SPAN><BR /><BR /><SPAN>I need to figure out how to import data to a attribute table with some conditions, meaning....example, I have let say 50 points made in a shapefile layer, I would like to import data from a excel sheet to them!</SPAN><BR /><BR /><SPAN>Ok, so to the part I do not understand, how do you make it happen IF the data from the imported excel sheet NEEDS to dictate the color of the point! Lets say IF the data have the number 5 or less..the point turns red, if the data have the 6 or more the point turns yellow....and so on! Also it needs to be different conditions to each point!</SPAN><BR /><BR /><SPAN>SO, again, I put 50/500/5000 points to a map.....import excel data/information to ArcMap and then JOIN the tables, then by "magic" depending on the values in the excelsheet my points will change color depending what condition I will give it?!?</SPAN><BR /><BR /><SPAN>Hope somebody understood my questions and can help me....</SPAN><BR /><BR /><SPAN>Regards from cold Sweden</SPAN><BR /><BR /><SPAN>//Mattias</SPAN></BODY></HTML> Wed, 16 Jan 2013 17:30:27 GMT https://community.esri.com/t5/data-management-questions/setting-conditions-to-the-attribute-table/m-p/219823#M12520 MattiasTancred 2013-01-16T17:30:27Z Re: Setting conditions to the attribute table! https://community.esri.com/t5/data-management-questions/setting-conditions-to-the-attribute-table/m-p/219824#M12521 <HTML><HEAD></HEAD><BODY><SPAN>Hi Mattias,</SPAN><BR /><BR /><SPAN>For setting the colors (called symbology in ArcGIS) you need to use the Layer Properties window &gt; Symbology tab. There you can define how the points will be shown on the map based on the values you have joined to them using the Excel sheet.</SPAN><BR /><BR /><SPAN>The </SPAN><A href="http://resources.arcgis.com/en/help/main/10.1/index.html#/Drawing_a_layer_using_categories/00s50000003m000000/">Help page with detailed instructions</A><SPAN>.</SPAN><BR /><BR /><SPAN>Good luck!</SPAN></BODY></HTML> Thu, 17 Jan 2013 07:25:40 GMT https://community.esri.com/t5/data-management-questions/setting-conditions-to-the-attribute-table/m-p/219824#M12521 AlexeyTereshenkov 2013-01-17T07:25:40Z