Use a Transform node to manipulate data based on the transformations added to the node. To manipulate data at multiple stages of a data transform, add a separate Transform node at each stage.
| Absolute Value | Takes the value from the field and returns its absolute value. |
|
CDP Hour CDP Day CDP Month CDP Quarter CDP Year |
Returns the a timestamp value truncated at the Year, Quarter, Month, Day, or Hour precision. When using the CDP time functions, Metrics will be aggregated at different granularities. See Calculated Insights Processing and Retention Times for more details. |
| Current Date | Returns the current date at the start of the query evaluation. All current_date calls within the same query return the same value. |
| Date Addition | Adds a number of days to the date value based on the integer value of the second function parameter. Returns the date that is the number of days after the start date. |
| Date Difference | Returns the number of days from start date to end date. |
| Date Subtraction | Subtracts a number of days from the date value based on the integer value of the second function parameter. Returns the date that is the number of days before the start date. |
| Date Truncation | Returns the timestamp expression truncated to the unit specified by the format model. |
| Day | Returns day component of the string or timestamp. |
|
Day of Week Day of Month Day of Year |
Returns the day of the week, month, or year for a date or timestamp. |
| Hour | Returns the hour component of the string or timestamp. |
| Left Trim | Removes leading spaces from strings. |
| Lowercase | Returns the input as an all-lowercase string. |
| Mod | Returns the remainder of a number divided by another number. |
| Month | Returns the month component of the string or timestamp. |
| Quarter | Returns the quarter component of the string or timestamp. |
| Random | Returns a random number between 0 (inclusive) and 1 (exclusive). |
| Regular Expression | Defines a sequence of characters, used to search and locate specific sequences of characters that match a pattern. |
| Regular Expression Extract | Creates dimension values by extracting them from a source dimension using Google RE2 regular expressions. |
| Regular Expression Replace | Extends the functionality of the REPLACE function by letting you search a string for a regular expression pattern. |
| Null If | Compares two expressions. If the values are equal, it returns NULL. If they are not equal, it returns the first expression. |
| Right Trim | Removes trailing spaces from strings. |
| Round | Rounds a number to the specified decimal place. |
| Substring | Returns a portion of the string beginning at a specified position and having a specified length. Alternatively, get a slice of the byte array starting at a specified position and having a specified length. |
| Trim | Removes leading and trailing spaces from strings. |
| To Date | Parses the date string expression with the format expression to a date. Returns null if the input isn’t valid. |
| To Timestamp | Parses the timestamp string expression with the format expression to a timestamp. Returns null if the input isn’t valid. |
| Uppercase | Returns the input as an all-uppercase string. |
| Year | Returns the year component of the string or timestamp. |