--- schema_version: "1" id: cd7ea0bb08ff8146dc3310ec65e72ec1e502c98d7883eb04fc1912f74fef58fb title: Using the Transform Node collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/data/264-0-0/c360_a_using_the_transform_node.md canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_using_the_transform_node.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: 9a9c8f8238807214777b4665b7a3d27cc15711a507f099984a27dcae6d42fef4 description: 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. products: - Data 360 release: "264" --- # Using the Transform Node 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.