nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Modelbuilder - Field Exists, Data Exists in ArcMap

FynnScharpen

Hello there,

lately, I'm working a lot with Modelbuilder in ArcGISPro and enjoying the upgrade.

I used models in Pro to check data and fields of attribute tables. Today I tried to develop such a model in ArcMap as well but couldn't find a similar function to "field exists" and "data exists" which I used in Pro. Are there similar functions I don't know of? 🙂 I'm not very experienced in Python so programming it on my own would be hard.

If you have any tips pls let me know. I would be grateful!

Kind regards from Germany!

Vind meer berichten getagd met

Desktop

Accepted answers

ABishop

Hello again @FynnScharpen

In ArcMap, you can add a tool to your model called table to table, and add an expression with definition query to determine if the output field exists or contains data. If the output contains data, you know if there are null values (you could reverse this to include the values that are not null as well). So, for your Name, Street, City, attributes you could write a definition query that looks like the query below (I have also included a screen shot of sample data used from our parcel dataset with PARCEL, KIND, and ANGLE fields to show you what the expression builder looks like - mine is Pro but should be the same in ArcMap):

NAME IS NOT NULL And STREET IS NOT NULL And CITY IS NOT NULL

All comments

BRHolmes

I have the same problem but I need the output to be a geodatabase feature class. As part of a model, I need to check to see if the fc has a GIS_Acres field. I also am not very experienced with python, but I have some code that I can use as a script in the model to check for the field, but I'm struggling with creating the output. Any help would be appreciated.

ABishop

You're welcome! I am glad this worked for you. 😀

ABishop

Hello again @FynnScharpen

NAME IS NOT NULL And STREET IS NOT NULL And CITY IS NOT NULL

FynnScharpen

Thanks for your help! 🙂

FynnScharpen

Before a friend gives me an attribute table that has to have for example name, street, and city he shall run the model that's checking if the 3 columns exist and if they include information.

The output should be a list that says:

Name: True

Street: False

City: True

So I don't have to put in the work and check every attribute table each time. instead, I can just run the model and ask for an update if he forgot smth. In ArcGISPro it already exists as logic functions but Map doesn't have such a thing

ABishop

Hello @FynnScharpen

To get a better understanding, what are you using the "field exists" and "data exists" functions to check for? There may be other ways to write this into a model.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.