Array Functions in Fusion

Question 1

What function adds values specified in parameters to an array and returns that array?

Answer 1

add (array; value1; value2; …)

Question 2

What verifies if an array contains the value?

Answer 2

contains (array; value)

Question 3

What removes duplicates inside an array?

Answer 3

distinct (array; [key])

*It uses the “key” argument to access properties inside complex objects. To access nested properties, use dot notation. The first item in an array is index 1.

Question 4

What creates a new array with all sub-array elements concatenated into it, recursively, up to the specified depth?

Answer 4

flatten (array)

Question 5

What concatenates all of the items of an array into a string, using the specified separator between each item?

Answer 5

join (array; separator)

Question 6

What returns an array of the properties of a given object or array?

Answer 6

keys (object)

Question 7

What returns the number of items in an array?

Answer 7

length (array)

Question 8

What returns a primitive array containing values of a complex array? This function allows filtering values. Use raw variable names for keys.

Answer 8

map (complex array; key;[key for filtering];[possible values for filtering])

Question 9

What merges one or more arrays into one array?

Answer 9

merge (array1; array2; …)

Question 10

What removes values specified in the parameters of an array? This function is effective only on primitive arrays of text or numbers.

Answer 10

remove (array; value1; value2; …)

Question 11

What array makes the first element of the array become the last element, the second element becomes the next-to-last element, and so on?

Answer 11

reverse (array)

Question 12

What returns a new array containing only selected items?

Answer 12

slice (array; start; [end])

Question 13

What formula is used to sort values of an array?

Answer 13

sort (array; [order]; [key])

Question 14

What are the valid values of the order parameter for a sort array?

Answer 14

asc - ascending order
desc - decsendign order
asc ci - case insensitive ascending order
desc ci - case insensitive descending order

Question 15

What formula returns the difference between two arrays?

Answer 15

arrayDifference [array1, array2, mode]

Question 16

What are the two values that can be used for the mode parameter of an arrayDifference formula?

Answer 16

classic - Returns a new array that contains all elements of array1 that do not exist in array
symmetric - Returns an array of elements that are not common to both arrays

Question 17

What function converts a collection into an array of key-value pairs?

Answer 17

toArray