Hi everyone this is my first time asking in Geonet
I have to make a model builder (I don’t have a lot experience on that) that give me as a result a Resume Table of NULL Value of all fields in Feature Class. I create a model using the following tools:
-Select layer by attribute (using of example the expression: [C_CAM_ANCHO_2] IS NULL)
-Summary Statistics (Field: C_CAM_ANCHO_2 Statistic Type: COUNT)
-Add field (Parameters= Field Name (Name), Field Type (Text), Field Length (30))
*Calculate field (Parameters= Field Name: Name, Expression: “C_CAM_ANCHO_2”)
*Note: I have to repeat this process depending on the amount of field that my Feature Class have. For example, if my Feature Class Road have 20 fields, I repeat this process 20 times.
-Merge I join the result of the process with the tool Merge selecting the fields that I need. In this case for example: Name (field) and FRECUENCY (field).
In the 1st image (ModelFor_One_Field) you can see how I use the model for just one field, in the 2nd imagen (ModelFor_One_Field_Tool) you see how looks the model as tool and then this model for each field on a Feature Class (Images ModelFor_20_Fields and ModelFor_20_Fields_Tool).
Well the thing is that I need to replicate the model for more than 30 different Feature Class, so I don’t know if I can simplify this model using iterators, other tools or model into another model. Can somebody guide me please?
In the end, what I need is a summary table like the one in the image “summary_null_table” with the frequency of null value for each field in a Feature Class.