Arrays

Split an array of objects into sub-arrays based on the value of a selected property, similar to "GROUP BY" in SQL.

The Array Join module combines messages arriving into an array of messages. It supports Time, Count, Mixed, Auto and PropertyChange modes.

Gets one property for each object in an Source Property and creates a new array, with the values of the properties, which is then written to Target Property. If an object does not have Property to Get then null is used as its value.

Omits Properties to Omit from all objects in Source Property and creates a new array of objects without the omitted properties, and writes the result to Target Property.

Picks Properties to Keep from all objects in Source Property and creates a new array of objects with only the picked properties, and writes the result to Target Property.

This Module uses a regular expression to filter out items in arrays on message properties. It has two modes of operation, one for filtering out items that matches the regular expression and one for filtering out items that don't. The message is then sent and the property is set to the array of remaining items.

This module is designed to be located in the middle of a flow.

Sorts an array of objects using the value of objects Key Property and according to the sort order specified in Key Values.

The module sorts and filters an array of objects by the specified Sort Property. Default sort order is ascending. If an object in the array is missing the Sort Property the object will be ignored and not included in the output. If the data type of the Sort Property is inconsistent in the array, no sorting will be done and the input value will passthrough the module.

The module accepts arrays and split them into individual messages sent to the next module(s).

This module is designed to be located in the middle of a flow.

Used to calculate statistics for an array of values on the incoming message.

The module flattens an array into an object. For example for inserting into a database. You have to be able to identify name and value properties on the incoming array to be able to convert it into a object.

The Join module combines messages arriving from different sources at slightly different times into an array of messages aligned on regular time intervals. For example, if you have three sensors sending data once per second you can use the Join module to deliver one message per second, containing an array with data from the three sensors.

The Window Module captures sequences of messages and produces arrays of messages on the Target Property. Either a specifed number of messages are captured in each window (Count mode) or messages can be captured during a specified time (Time mode). It is possible to get both overlapping (sliding) windows and non-overlapping (tumbling) windows, by using the Shift setting.

Converts an object to an array of objects. Each key-value pair in the incoming object becomes a separate object in the new array. Those new objects have two properties, one for the key and one for the value.

• The key from the key-value pair becomes a value in the new object with Name Property as its key.
• The value from the key-value pair becomes a value in the new object with Value Property as its key.