topic Re: How to label with multiple fields when some are empty in ArcGIS Pro Questions

How to label with multiple fields when some are empty

LarissaBoundy — Wed, 12 Jan 2022 03:43:40 GMT

Hello,

I am using ArcGIS Pro and trying to get labels in a sensible way. The layer and variables I am using to create labels can have up to five classes (Regional Ecosystems, three in the screen shot below).

I have tried [$feature.RE1 +"/"+$feature.RE2+"/"+ $feature.RE3], which gives the below result, my issue being that when there was only one RE, there are is now // after the label which obviously looks silly.

Is there a way to get the extra RE labels and / to only appear if the field is not empty?

Thank you.

Re: How to label with multiple fields when some are empty

JayantaPoddar — Wed, 12 Jan 2022 04:41:23 GMT

Could you use Python Language?

Could you check if rstrip('/') function works for you?

([RE1]+'/'+[RE2]+'/'+[RE3]).rstrip('/')

Re: How to label with multiple fields when some are empty

LarissaBoundy — Wed, 12 Jan 2022 05:35:47 GMT

Hi Jayanta,

Thanks for your comment. I just tried that, got an error message, and ($feature.RE1 +"/"+$feature.RE2+"/"+ $feature.RE3).rstrip('/')

For both I got the message

Thank you.

Re: How to label with multiple fields when some are empty

JayantaPoddar — Wed, 12 Jan 2022 06:18:57 GMT

Copy-paste my script if you have changed the language to Python.

No need to use ~~$feature.~~ Also call the fields from the Fields list.

Please share screenshot of your label expression as well.

Re: How to label with multiple fields when some are empty

LarissaBoundy — Wed, 12 Jan 2022 06:21:32 GMT

Thank you, I hadn't changed language to Python, but still did not work

Re: How to label with multiple fields when some are empty

JayantaPoddar — Wed, 12 Jan 2022 06:47:39 GMT

alright. Check this one (Python)

(([RE1]+'/'+[RE2]+'/'+[RE3]).rstrip('/ / ')).rstrip('/')

([RE1]+'/'+[RE2]+'/'+[RE3]).replace('/ /','')

Re: How to label with multiple fields when some are empty

HuubZwart — Wed, 12 Jan 2022 07:59:24 GMT

Not the most elegant solution, but you could employ the removeEmpty parameter from Split (Arcade). I.e. concatenate the values using Concatenate, split the new string with the removeEmpty parameter set and then concatenate again to get your label.

Re: How to label with multiple fields when some are empty

IlkaIllers1 — Wed, 12 Jan 2022 07:59:22 GMT

I use something like this in the advanced expression of Python:

def FindLabel ([RE1],[RE2],[RE3]):
a = [RE1]
b = [RE2]
c = [RE3]
return "/".join([str(i) for i in [a, b, c] if i is not None])

Re: How to label with multiple fields when some are empty

IlkaIllers1 — Wed, 12 Jan 2022 08:04:54 GMT

Sorry, I just tried it and realised it doesn't work with "/". It still has the unwanted extra //. Curious! The same code with ", " instead works fine for me. I don't know why, sorry!

def FindLabel ([RE1],[RE2],[RE3]):
a = [RE1]
b = [RE2]
c = [RE3]
return ", ".join([str(i) for i in [a, b, c] if i is not None])

Re: How to label with multiple fields when some are empty

IlkaIllers1 — Wed, 12 Jan 2022 08:37:28 GMT

Well, I was foiled by my own data! Turns out it does work when you check that fields are really None (<Null>) instead of empty! This is my failsafe expression:

def FindLabel ([RE1],[RE2],[RE3]):
a = [RE1]
b = [RE2]
c = [RE3]
return "/".join([str(i) for i in [a, b, c] if i is not None and i !=""])

Re: How to label with multiple fields when some are empty

JohannesLindner — Wed, 12 Jan 2022 09:15:50 GMT

var raw_re = [$feature.RE1, $feature.RE2, $feature.RE3, $feature.RE4, $feature.RE5] var filled_re = [] for(var i in raw_re) { if(!IsEmpty(raw_re[i])) { Push(filled_re, raw_re[i]) } } return Concatenate(filled_re, "/")

Re: How to label with multiple fields when some are empty

MicZatorsky_AEC — Wed, 12 Jan 2022 22:26:24 GMT

IlkaIllers1 handling of None is important. Null requires special handling.
Null in the attribute table means None in python.
And None plus anything equals None

Re: How to label with multiple fields when some are empty

LarissaBoundy — Thu, 13 Jan 2022 00:53:06 GMT

Thank you so much you legend, the first one was successful.

Re: How to label with multiple fields when some are empty

LarissaBoundy — Thu, 13 Jan 2022 00:54:37 GMT

Thank you everyone, Jayanta's suggestion below was successful!

(([RE1]+'/'+[RE2]+'/'+[RE3]).rstrip('/ / ')).rstrip('/')