Skip Null Values Attribute Assistant

835
10
06-09-2020 12:34 PM
KarinaLivingston
Occasional Contributor

Hello, 

I am using the attribute assistant to populate a GIS ID which consists of a location ID - Equipment ID. I have been able to get the assistant to work using the following expression in the Value Info field. ([LOCATIONID]+"-"+[EQUIPMENTID]). This returns GIS IDs but some have a null portion. However, I need a way for the attribute assistant to skip (or not populate) if either the location ID or equipment ID is null. Is there a way to do this? I have tried NOT NULL in a variety of ways but was not successful. 

0 Kudos
10 Replies
KarinaLivingston
Occasional Contributor

Hi Xander Bakker‌,

No worries! Thanks so much, this makes sense. I was going in circles reading post after post.

I work for a small utility company which means we are behind most, we are currently transitioning to 10.6.1 and are not sure when we will be able to make the move to ArcGIS Pro. I see all the demos and new capabilities and can't wait but for now, we have to find workarounds.

Thanks Again,

Karina

0 Kudos