how to merge two arrays excluding null values

Question

hi, 
 I have two arrays,{"","1"} and {"2","3"} 
 I want to merge them, but exclude null and have something like this 
 {"1","2","3}. 
 
 Any help is appreciated

Stefan Helzle · Accepted Answer

filter(a!isNotNullOrEmpty(_), union({"","1"}, {"2","3"}))

Mike Schmitt · Answer

For an implementation that avoids the old and clunky primitive looping functions like filter() , we can use a!forEach() in this (and almost all other) use cases: 
 a!localVariables(
 local!array1: {"", "1"},
 local!array2: {"2", "3"},

a!flatten(
 a!forEach(
 union(local!array1, local!array2),
 if(
 a!isNotNullOrEmpty(fv!item),
 fv!item,
 {}
 )
 )
 )
)

Prasanta Paul · Answer

a!localVariables(
local!a: { "", "1" },
local!b: { "2", "3" },
a!forEach(
items:{local!a,local!b},
expression: if(isnull(fv!item),{}, fv!item)
)
)

how to merge two arrays excluding null values

Top Replies