Latest Contributions by VishalShah2

Hello, I am new to using attribute assistant and need some help. I need to be able to populate a field on the fly called Total Activations (field name TotalActivations) based on Activation1, Activation2, Activation3, Activation4, Activation5, and Activation6. I can create a script in Python to do this, but not sure how to do it in Attribute Assistant. The reason why i would like to use Attribute Assistant is so that an user does not have to run a script tool every time an update is made. Here is what my table looks like: If the value is 'Yes' in any of the activation numbered fields, that takes the value of 1, any 'No' or <Null> values takes a value of 0. So the first line item would total 1. My python script is the following: import arcpy poles = 'Test2' fieldList = ("Activation1", "Activation2", "Activation3", "Activation4", "Activation5", "Activation6", "TotalActivations") with arcpy.da.UpdateCursor(poles, fieldList) as cursor: for row in cursor: n = 0 if row[0] == 'Yes': a = 1 elif row[0] == 'No' or row[0] is None: a = 0 if row[1] == 'Yes': b = 1 elif row[1] == 'No' or row[1] is None: b = 0 if row[2] == 'Yes': c = 1 elif row[2] == 'No' or row[2] is None: c = 0 if row[3] == 'Yes': d = 1 elif row[3] == 'No' or row[3] is None: d = 0 if row[4] == 'Yes': e = 1 elif row[4] == 'No' or row[4] is None: e = 0 if row[5] == 'Yes': f = 1 elif row[5] == 'No' or row[5] is None: f = 0 n = a + b + c + d + e + f row[6] = n cursor.updateRow(row) ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ How do I translate this into Attribute Assistant? ... View more

Currently I'm using SUMIFs in Excel to calculate some values in a spreadsheet and then having to make the updates manually in my attribute tables or reloading all of my data into the feature class. Is there a way to do SUMIFs using Python in ArcMap? One method I came up with was using Summary Statistics. For my current workflow, I'd need to do it three different times and then either join the tables or use cursors to populate the information. I need to get the sum of a field based on the address for another field's values. Another calculation is a max value based on address for another field, and then lastly need a count for an address for another field. My original thought process was to create a basic python tool using arcpy.Statistics_analysis (Summary Statistics) where my sum fields would be [[EquipmentCount, SUM], [EquipmentLocation, MAX], [Address, COUNT]] and my case field would be Address. The output would ideally be In Memory where I can use search cursor to build a dictionary where Address is my Key and the rest of the values would be the values. Using Update Cursor, I would populate the TotalCount field (using value of EquipmentCount - SUM), UniqueCount field (using EquipmentLocation - MAX), and Cutomers field (using Address - COUNT). However I am trying to find another way to do this without having to go down the summary statistics route. I was hoping to use Field Calculator if possible or another alternative. I do not have any experience using the Pro-Logic in Field Calculators or numpy for that matter. ... View more

Hello, I am working on putting together a custom tool that helps populate information into four fields within each feature class in the database. The script is pretty straight forward and has no issues. My issue is I have to create 22 tools to do the same thing by each feature class and creating a value list in the parameters section of the script tool would be too cumbersome. Is it possible to have one table that can be automatically pulled right into a drop-down and the only thing I'd have to do is update that table whenever it needs to be updated? ... View more