Array utilities

Use these utilities to work with arrays.

Append to array

Adds an object (string, integer, etc.) to the end of an existing array or instantiates an array to which objects will later be added. If no array is given, or the given array does not exist, the member will be added to an empty array.

Input

["joe", "jane", "jill"]

New_Member

"bob"

Output

["joe", "jane", "jill", "bob"]

Chunk array

Divides an existing array into smaller arrays.

Input

["joe", "jane", "jill", "bob", "doug", "mary"]

Chunk_Size

3

Output

[ [ "joe", "jane", "jill"], [ "bob", "doug","mary" ] ]

Concat arrays

Combines 2 arrays into a single array. Objects that appear in both arrays are duplicated in the concatenated result.

Input

["joe", "jane", "jill"]

Second_Array

["bob", "doug", "mary", "jill", "joe"]

Output

["joe", "jane", "jill","bob", "doug","mary", "jill", "joe"]

Extract field from records

Given a list of records and a field name, extract the value for the provided field name for each record.

Input

[ 

  { "name": "John Doe", "details": { "age": 23 } },

  { "name": "Jane Doe", "details": {"age": 97 } }

]

Field_Path

details.age

Output

[23, 97]

Filter array

Filters an array to produce a subset of the data based on the Filter_Func_ operator and Filter definition. The FieldPath is the location of the array within the input where the data is located. This path is only required when the dataset is nested.

Input

["joe", "jane", "jill","bob", "doug","mary", "jill", "joe"]

Filter_Func

"Contains"

*Field_Path *

""

Filter_Arg

j

Output

["joe", "jane", "jill", "jill", "joe"]

Get last item from array

Returns the last object in the array.

Input

["joe", "jane", "jill","bob", "doug","mary" ]

Output

"mary"

Join strings

Returns a single string of all objects in the array separated by the delimiter.

Input

["joe", "jane", "jill","bob", "doug","mary" ]

Delimiter

||

Output

"joe||jane||jill||bob||doug||mary||jill||joe"

Prepend to array

Adds an object (string, integer, etc.) to the beginning of an existing array, or instantiates an array to which objects will later be added. If no array is given, or the given array does not exist, the member will be added to an empty array.

Input

["joe", "jane", "jill"]

New_Member

"bob"

Output

["bob", "joe", "jane", "jill"]

Reverse array

Reverses the order of the items in a given array.

Input

["joe", "jane", "jill", "bob"]

Output

["bob", "jill", "jane", "joe"]

Rollup numeric array

Performs a rollup function on an array of numbers.

Input

[1, 2, 3, 4, 5]

Rollup_Function

Product

Output

120

Slice array

Returns a slice of the given array, meaning, the first object after Slice_Start up to, and including the object at Slice_End.

Input

[1, 2, 3, 4, 5]

Slice_Start

2

Slice_End

4

Output

[3, 4]

Slice array from start

Returns a slice of the given array, from the first object in the array up until the specified index.

Input

[1, 2, 3, 4, 5]

Slice_End

4

Output

[1, 2, 3, 4]

Slice array to end

Returns a slice of the given array, from the specified index up to, and including the last object.

Input

[1, 2, 3, 4, 5]

Slice_Start

2

Output

[3, 4, 5]

Sort array

Sorts the objects in the given array. Supports strings, numbers, and datetime strings.

Input

["joe", "jane", "jill","bob", "doug","mary" ]

Sort_Order

Ascending

Output

["bob", "doug", "jane", "jill", "joe", "mary"]

Subtract arrays

Compare two arrays (left and right) to receive 3 sub-arrays:

• Intersection - objects that exist in both arrays.
• Left_dif - objects that exist only in the first array.
• Right_dif - objects that exist only in the second array.

Left_Array

["joe", "jane", "jill","bob", "doug","mary", 1, 2, 3 ]

Right_Array

["joe", "jane", "jill","bob", "doug","mary"]

Output

"intersection": ["bob", "doug", "jane", "jill", "joe", "mary"],"left_dif": [3, 1, 2],"right_dif":[]

Unique on array

Returns only unique values from the original array.

Input

["joe", "jane", "jill", "bob", "doug","mary", "jill", "joe"]

Output

["joe", "jane", "jill","bob", "doug","mary", ]