topic attribute assistant/intersect_stats/using an expression in Data Management Questions https://community.esri.com/t5/data-management-questions/attribute-assistant-intersect-stats-using-an/m-p/429579#M24547 <HTML><HEAD></HEAD><BODY><P>I want to use atttribute assistant to get the diameter of a pipe, and use it to fill the diameter field of an intersecting/end point (could be either). I was using INTERSECT_STATS to get the minimum value (if two pipes touch the point, get the smaller diameter). The problem is our domain for pipe diameters has "other" as -1 and "unknown" as 0. In that case I would like to use the diameter from the other intersecting pipe. I want to do some sort of "if [Diameter] NOT IN ( -1,0) then use minimum diameter, else use max" Is this type of thing possible?</P></BODY></HTML> Thu, 24 Sep 2015 23:41:04 GMT KiraNelson 2015-09-24T23:41:04Z attribute assistant/intersect_stats/using an expression https://community.esri.com/t5/data-management-questions/attribute-assistant-intersect-stats-using-an/m-p/429579#M24547 <HTML><HEAD></HEAD><BODY><P>I want to use atttribute assistant to get the diameter of a pipe, and use it to fill the diameter field of an intersecting/end point (could be either). I was using INTERSECT_STATS to get the minimum value (if two pipes touch the point, get the smaller diameter). The problem is our domain for pipe diameters has "other" as -1 and "unknown" as 0. In that case I would like to use the diameter from the other intersecting pipe. I want to do some sort of "if [Diameter] NOT IN ( -1,0) then use minimum diameter, else use max" Is this type of thing possible?</P></BODY></HTML> Thu, 24 Sep 2015 23:41:04 GMT https://community.esri.com/t5/data-management-questions/attribute-assistant-intersect-stats-using-an/m-p/429579#M24547 KiraNelson 2015-09-24T23:41:04Z