How does Arcade handle nulls?

Bud — Mon, 07 Mar 2022 07:48:53 GMT

Examples:

Can we do math on nulls?
- 1 + null = ?
Can we concatenate nulls?
- "foo" + null = ?
How does aggregating on nulls work?
- Average($layer, "flag_1")
- If there are nulls in the "flag_1" field, will they be included in the average's count?
Does null equal null?
Does null not equal null?

Is there anything else about nulls that we should be aware of?

Thanks.

Re: How does Arcade handle nulls?

JohannesLindner — Mon, 07 Mar 2022 08:20:58 GMT

Null values are basically handled like zero (or "" for strings), though I'm trying to get that changed.

Console("1 + null = " + (1 + null)) Console("'foo' + null = " + ('foo' + null)) Console("null == null = " + (null == null)) Console("null != null = " + (null != null)) Console("\nOther stuff:") Console("Abs(null) = " + Abs(null)) Console("Min([null, 1, 2]) = " + Min([null, 1, 2]))

1 + null = 1
'foo' + null = foo
null == null = true
null != null = false

Other stuff:
Abs(null) = 0
Min([null, 1, 2]) = 0

How does aggregating on nulls work? If there are nulls in the "flag_1" field, will they be included in the average's count?

If you aggregate on a feature set, nulls will be filtered out (at least for Min). For arrays, You have to do it yourself.

topic How does Arcade handle nulls? in ArcGIS Pro Questions

How does Arcade handle nulls?

Re: How does Arcade handle nulls?