Arrays in the Factory
Arrays are functions which perform operations on the whole column, and not on the single values in each cell.
Rulex Platform formula | ||
|---|---|---|
Function | Formula | Description |
enum(group) | Enumerates the rows in a dataset, in ascending order, optionally grouped by a selected attribute. | |
fillDown(column, group, fillall) | Returns a copy of the specified column, filling all the missing values with the last valid value, optionally grouped by selected attributes. If there are rows which remain empty, as they do not have a previous valid value, a fillUp operation can then be performed, using the next valid value. | |
fillLinear(column, group) | Fills any missing values for a specified attribute with a value, based on the other values present in the attribute, using a linear interpolation method. The linear interpolation links two adjacent values with a straight line, graphically: this means that the gap is filled with values with equal distance one to the other. | |
fillLinear(column, group) | Returns a copy of the selected column, filling all the missing values with the next valid value, optionally grouped by selected attributes. If there are rows which remain empty, as they do not have a next valid value, a fillDown operation can then be performed, using the previous valid value. | |
integer(column) | Returns the values of the specified attribute, cast to the integer data type. | |
len(column) | Returns the number of values present in the attribute, including missing values. | |
matchHeaders(column) | Returns the value in the corresponding row for the selected column. | |
nominal(column) | Returns the values of the specified attribute cast to the nominal data type. | |
perm(column) | Returns the values of a selected attribute in a random order. | |
rank(column, usemissing) | Returns the values of a column in ascending alphabetic order. By default missing values are considered in the ranking. | |
shift(column, shift, group, cyclic) | Returns the attribute column shifted by the shift value. The shift can be performed according to the groups defined in the group parameter. | |
Parameters in bold are mandatory.