Loading
Feature degradation | Gmail Email delivery failureRead More
Salesforce Data Pipelines
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
            Why am I receiving a syntax error in the formula node?

            You are here:

            1. Salesforce Help
            2. Docs
            3. Salesforce Data Pipelines

            Why am I receiving a syntax error in the formula node?

            You can perform several types of transformations on fields in Data Prep. However, some field API names are unavailable for these transformations.

            If you receive an error similar to this, you could be using an unavailable API name. 

            There’s a syntax error in the formula node REPLACE0’s SQL expression. Update the formula’s SQL syntax in target column Title_replace at row 1, column 14.

            You can’t use these API names in a transformation.

            • DAY
            • DAYOFWEEK
            • DAYOFMONTH
            • DAYOFYEAR
            • HOUR
            • LAST_DAY
            • MONTH
            • SECOND
            • TITLE
            • WEEK

            To use these fields, use an Edit Attributes transformation to change the field’s API name.

            If you still receive an error, the cause could be another type of syntax error.

             
            Loading
            Salesforce Help | Article