How can I add two arrays?

Hi Ιωάννη,

get some ideas here:

https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/list-of-values-5c7e33c170047023951d2319

Νίκος

With concat() ?

I'm not sure why the Ninox team made array manipulation so difficult. It's like they wanted arrays to be read-only after the arrays are defined. One way is to break the arrays down and then rebuild them like this...

let a := 1;
let b := 2;
let c := 3;
let d := 4;
let ar1 := [a, b, c];
let ar2 := [d];
let ar3 := concat(ar1) + ", " + concat(ar2);
let ar4 := split(replace(ar3, ", ", ","), ",")

You can combine the lines for ar3 and ar4, but I separated them so it would be easier to see what's going on.

Nice timing Steven :)

One of the problems with this approach is now your array values are text instead of number and if you want to do any arithmetic with the values you will have to convert them to number type like...

number(item(ar4, 1))

@Ioannis, it's possible and once you have the code worked out it will do all the work for you. Post what you want to do and I will try to help.

@Jörg, that just returns the values that are not of type array, ie, 2 & 7.

Hi Jörg,

numbers() is not a function in the Mac app. Here is a screenshot of my test...

Hi Jörg,

Thank you for posting this. The array request has been going on for some time now... is this recently implemented functionality?

Best, Sean

Ioannis You’re welcome. Looks like you’ve got it.

 I’m familiar with the unique() function’s named purpose, but was not aware that it would combine an array with other values. The topic of arrays has gone on for several months now and this is the first time I’ve seen this solution.

Hi Ioannis

That is one of the problems with those array functions at the moment... they always return text values regardless of the input type. Another problem is any value/item that has a "," in it (ie, "Acme, Inc") will cause the value to be split at that point because you can't choose the concatenating character in the concat() function; strange considering you have to choose the splitting character in the split() function.

Jörg's solution using unique() works well as long as you don't need to duplicate items in your array. It solves the number value issue as well as the "," issue.

Ioannis

Sorry, I got two threads mixed up in my head. In your example ar3 becomes an array with a single item equal to "1, 2, 3, 4". You can test this with item(ar3, 0). If you use any other index you will get null as the return value because there is now only one item in the array

Yes, I'm familiar with that thread. I'm curious why you would choose that approach instead of one like this...

let array := numbers('Multiple choice');
let add := 10;
array := unique(array, add)

Do you have duplicate values?

I just noticed that it could have reduced it to 2 lines...

let array := numbers('Multiple choice');
array := unique(array, 10)

You can also use it with slice() to insert items...

let myArray := [1,2,3,4,7,8,9];
myArray := unique(slice(myArray, 0, 4), 5, 6, slice(myArray, 4, 7))

The second index position of the slice() function is not inclusive.

works, but I can't find a documentary about it

let mA := ["A", "B", "C"];
let mB := ["X", "Y", "Z"];
let mC := array(mA, mB);
concat(mC)

Johannes, you can find the information here...

https://ninox.com/en/manual/calculations/reference-of-functions-and-language