how to remove all nulls in array and get the corresponding index of the null value
Hello Appian people,
local!arr:{1,2,null,3,null}
loca!val:{1,2,3,4,5}
I have a function that gets null indexes in an array local!arr then used that indexes to remove the value from the local!val array.
and also remove the value found in the local!arr.
/*Get null indices */
local!getNullIndices: a!forEach(
items: local!arr,
expression: if(isnull(fv!item), fv!index, null())
),
local!removeNullIndices: remove(
local!getNullIndices,
where(
a!forEach(
items: local!getNullIndices,
expression: if(a!isNullOrEmpty(fv!item), true, false)
)
)
),
/* Removed found null in data item array */
local!data: remove(
local!arr,
where(
a!forEach(
items: local!arr,
expression: if(a!isNullOrEmpty(fv!item), true, false)
)
)
),
local!updatedVal:remove(
loca!val,
removeNullIndices
)
expected value for updatedVal is: {1,2,4}
Do you have any ideas to optimize this implementation? Thank you
