Functions, Operators, and Constants¶
There are many functions, operators, and constants used in the Clario Filter and Transform nodes. Refer to the lists below.
Functions included¶
| Function | Description | Type |
|---|---|---|
| Absolute | Computes the absolute value of an attribute. | Numeric |
| Add Days | Returns a date with a specified number of days added to the date. | Date |
| Arc Cosine | Input is a number between -1 and 1. Output is in degrees. | Numeric |
| Arc Sine | Input is a number between -1 and 1. Output is in degrees. | Numeric |
| Arc Tangent | Input is a number, output is in degrees. | Numeric |
| Average | Computes the average of two or more attributes. | Numeric |
| Ceiling | Converts a number up to the next highest integer. ex. 4.2 becomes 5 | Numeric |
| Concatenate | Combines multiple strings into one string. | String |
| Condition | Creates a conditional (if, then, else). | Boolean |
| Cosine | Input is a number in degrees. | Numeric |
| Date To String | Converts a date attribute to a string. | String |
| Day Of Month | Parse the numeric day from a date variable. ex. 4/1/2011 becomes 1 | Numeric |
| Days Between Dates | Computes the number of days between a range of dates. | Numeric |
| Exp(x) | Computes the exponential function of an attribute, Euler’s number e to the x-th power. | Numeric |
| Floor | Converts a number to the next lowest integer. ex. 4.8 becomes 4 | Numeric |
| Hours Between Dates | Computes the number of hours between a range of dates. | Numeric |
| In | Returns a Boolean value (true or false), whether an attribute/constant is contained in another attribute/constant. | Boolean |
| Index | Returns a specified character in a string variable. | String |
| Length | Returns the length of a string attribute. | Numeric |
| Logarithm | Computes the natural logarithm of the attribute. | Numeric |
| Maximum | Computes the maximum value of two or more attributes. | Numeric |
| Minimum | Computes the minimum value of two or more attributes. | Numeric |
| Minutes Between Dates | Computes the number of minutes between a range of dates. | Numeric |
| Modulus | Computes the remainder after division of two numbers. ex. 5 mod 2 = 1, 16 mod 7 = 2 | Numeric |
| Month Of Year | Parses the numeric month (1-12) from a date. | Numeric |
| Not In | Returns a Boolean value (true or false), whether an attribute/constant is not contained in another attribute/constant. | Boolean |
| Number To String | Converts a number to a string. | String |
| Pad Left | Pads the left side of an attribute with a string constant to a total specified length. | String |
| Parenthesis | Inserts open and close parentheses in an equation or function. | |
| Power of Value pow(x, n) | Raises the number’s value (x) to the nth power. | Numeric |
| Quarter of Year | Returns a value 1-4 for the quarter of the year in which a date falls. | Numeric |
| Random | Generates a random number. | Numeric |
| Replace | Replaces a substring of a string variable with a new string. | String |
| Round | Rounds a number to a specified number of digits. | Numeric |
| Row Count | Returns the number of rows beginning at a specified row. | Numeric |
| Seconds Between Dates | Computes the number of seconds between a range of dates. | Numeric |
| Sine | Input is a number in degrees. | Numeric |
| Square Root | Computes the square root. | Numeric |
| String To Number | Converts a string to a number. | Numeric |
| Substring | Returns a portion of a variable. | String |
| Tangent | Input is a number in degrees. | Numeric |
| To Lower Case | Converts to all lower case. | String |
| To Upper Case | Converts to all upper case. | String |
| Trim | Trims leading and trailing spaces from a string. | String |
| Verify | Returns a Boolean value (true or false), whether a string attribute contains a string constant. | Boolean |
| Week Of Year | Returns a value 1-52 for the week of the year in which a date falls. | Numeric |
| Year Of Date | Parses the numeric year from a date. | Numeric |
Operators included¶
Operators are necessary for math and logic expressions. The default operator is ‘+’. Click on the drop down box to change this to another operator below.
| Operator | Description |
|---|---|
| + | Add |
| - | Subtract |
| / | Divide |
| * | Multiply |
| == | Equal to |
| != | Not Equal to |
| > | Greater than |
| < | Less than |
| >= | Greater than or Equal to |
| <= | Less than or Equal to |
| AND | And |
| OR | Or |
Constants¶
Constants are sometimes needed as inputs to functions and can be combined with attribute values. Drag one of the constants into the work area, and then type in its value.
| Constant | Description |
|---|---|
| String | Create a string constant ex. ‘Y’ |
| Number | Create a numeric constant ex. 1 |
| Date | Create a date constant |
| Null | Create a null variable ex. Replace 999 with null to calculate a more accurate mean. |
