The function list displays all available CLEM functions and operators. Scroll to select a function from the list, or, for easier searching, use the drop-down list to display a subset of functions or operators.
|Operators||Lists all the operators you can use when building expressions. Operators are also available from the buttons.|
|Information||Used to gain insight into field values. For example, the function
|Conversion||Used to construct new fields or convert storage type. For example, the function
|Comparison||Used to compare field values to each other or to a specified string. For example,
|Logical||Used to perform logical operations, such as
|Numeric||Used to perform numeric calculations, such as the natural log of field values.|
|Trigonometric||Used to perform trigonometric calculations, such as the arccosine of a specified angle.|
|Probability||Returns probabilities that are based on various distributions, such as probability that a value from Student's t distribution is less than a specific value.|
|Spatial Functions||Used to perform spatial calculations on geospatial data.|
|Bitwise||Used to manipulate integers as bit patterns.|
|Random||Used to randomly select items or generate numbers.|
|String||Used to perform various operations on strings, such as
|Date and time||Used to perform various operations on date, time, and timestamp fields.|
|Sequence||Used to gain insight into the record sequence of a data set or perform operations that are based on that sequence.|
|Global||Used to access global values that are created by a Set Globals node. For example,
|Blanks and Null||Used to access, flag, and frequently fill user-specified blanks or system-missing values. For
|Special Fields||Used to denote the specific fields under examination. For example,
After you select a group of functions, double-click to insert the functions into the Expression box at the point indicated by the position of the cursor.
You can run an SPSS Modeler desktop stream file (.str) that contains database functions. But they aren't yet available in the Expression Builder user interface.