Loading
About Salesforce Data 360
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Using the Transform Node

            You are here:

            1. Salesforce Help
            2. Docs
            3. Data 360

            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.
            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.
            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.
            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.
             
            Loading
            Salesforce Help | Article