Blank values from relevant are "" in AGOL but Null in ArcPro

199
1
02-18-2021 08:18 AM
DougBrowning
MVP Notable Contributor

In the past the fact 123 uses "" and not null has been an issue.  But now I am seeing that Pro is showing "" as Null somehow.  I am looking directly at the hosted feature service in both.  This actually means needing diff code in AGOL vs Pro to check for them.

In AGOL 

BlankValuesinAGOL.JPG

In Pro

DougBrowning_0-1613664930916.png

I am not seeing a domain or anything.  How is this happening?

For Arcade will IsEmpty do it in both cases?

Thanks for any info

0 Kudos
1 Reply
XanderBakker
Esri Esteemed Contributor

Hi @DougBrowning ,

IsEmpty will return true if the provided value is null or an empty string. So yes, it should be able to detect them both.

https://developers.arcgis.com/arcade/function-reference/logical_functions/#isempty 

0 Kudos