Brainy

Solved

how to merge two arrays excluding null values

7 replies
32 views

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

stefanhelzle0001Answer

Brainy

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

stefanhelzle0001Answer

Brainy

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

K

kowsalyav7826Author

Brainy

just curious to know, what does this return if both arrays does not have null values

stefanhelzle0001

Brainy

Just give it a try ...

mikes0011

Brainy

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,
        {}
      )
    )
  )
)

The Expression Guru

K

kowsalyav7826Author

Brainy

I will try this

K

kowsalyav7826Author

Brainy

tried this, it worked, thank you

prasantap0900

Participating Frequently

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

Sign up

Login with SSO

Login to the community

Login with SSO