Most efficient way to replace null values in an array with 0?

pearlfranz

Certified Associate Developer

2 months ago

Currently using a!forEach and a!isNullOrEmpty to replace all null values in an array of integers with 0, but would love to learn the most efficient way to do so. Is apply() the way to go here? A different function? Many thanks for any and all help!

Discussion posts and replies are publicly visible

Top Replies

Yogi Patel 2 months ago +2
Certified Associate Developer

The following code snippet might be helpful: a!localVariables( local!data: { 1, null, 0, 10, null }, local!updatedData: a!update( local!data, wherecontains(tointeger(null()), local!data), 0…
Peter Lewis 2 months ago +1
Appian Employee

Luckily the a!defaultValue() function does exactly what you're looking for! You just have to run it using a!forEach() to apply it to a list of values: a!localVariables( local!data: {1, 2, null, 4,…

Parents

Yogi Patel

Certified Associate Developer

2 months ago

The following code snippet might be helpful:

a!localVariables(
  local!data: { 1, null, 0, 10, null },
  local!updatedData: a!update(
    local!data,
    wherecontains(tointeger(null()), local!data),
    0
  ),
  local!updatedData
)

Reply

Yogi Patel

Certified Associate Developer

2 months ago

The following code snippet might be helpful:

a!localVariables(
  local!data: { 1, null, 0, 10, null },
  local!updatedData: a!update(
    local!data,
    wherecontains(tointeger(null()), local!data),
    0
  ),
  local!updatedData
)

Children

No Data