Add null to array

It should just be the case of determine the difference in size of the arrays and adding to the smaller array an enumeration of null values to fill out the difference.

Hello peanut,

hope this is what you are asking for, this will only display a null value as output but will not add the value to the array.

a!localVariables(
  local!arr:{1},
  local!values:{1,2,3},
  {
   a!flatten(
     a!forEach(
       items: local!values,
       expression: {
         index(local!arr,fv!index,null())
       }
     )
   )
  }
)

We can wait for the experts to solve your question!

...like this:

fn!append(
    local!arr,
    fn!repeat(fn!length(local!value)-length(local!arr), null)
  )

Obviously you'd have check beforehand that local!arr was in fact smaller than local!value but otherwise this should do the trick,...

i would rather ask, if the implementation is 100% fine, if you are required to add null values into your array. Can you let us in the whole story? My feeling is, we should fix the root cause instead of the symptom

Hi,

You can try this solution, this will add null values to the array which has a smaller number of values into it.

a!localVariables(
local!arr: { 1 },
local!value: { 1, 3, 5 },
local!diff: if(
a!isNullOrEmpty(difference(local!arr, local!value)),
difference(local!value, local!arr),
difference(local!arr, local!value)
),
if(
a!isNullOrEmpty(local!diff),
local!diff,
if(
a!isNullOrEmpty(difference(local!arr, local!value)),
append(
local!arr,
a!forEach(items: local!diff, expression: null())
),
append(
local!value,
a!forEach(items: local!diff, expression: null())
),
)
)
)

hi prachig,
please use this feature when you inserting code

Hi Richard,

Yes definitely I'll use this feature from now. Thank you for this information.