Applying any function (SQL) Custom Value allows you to write a query needed for your Selection using any of the SFMC-supported SQL operators. You can use the board freely allowing you to either code from scratch or copy-paste existing queries applied in the SELECT clause to generate new values as necessary.
Important note: only SQL functions applied in the SELECT clause work. In case you copy queries with a FROM/WHERE statement, or that require other statements after the SELECT clause eg. a GROUP BY, it won't work.
Watch this video to learn more about Applying any function (SQL) Custom Value.
How to create an Apply any function (SQL) Custom Value?
-
Go to Custom Values section > Add new value button
-
Provide a name for the Custom Value > Apply formula to a field > Click Next > Apply any function > Click Next
-
Select the type of value that you want to populate
-
Use the board to write your query
-
Optionally, you can use the suggested functions via the Insert Function dropdown > Click Insert Formula once you found the operator you need.
The chosen formula including the parameters needed for it will be inserted on the board. You will then just need to replace the parameters with actual fields or text.
Use the Insert Field function to automatically add the chosen Data Extension and field to the board as part of the parameters if necessary.
Choose the Data Extension and field > Click Insert Field
-
Click Check syntax to validate the query > Click Save
-
Drag-and-drop the new Custom Value to the Target Data Extension fields
Scenario
You want to get the First Name of your Contacts in Camel Case for your email campaign. In order to achieve that, you want to convert only the first character of each record to uppercase, and the rest to lowercase.
Follow these step-by-step instructions to achieve this.
You can also create reusable Custom Values. Follow this link to learn how to create reusable Custom Values.
Related Links:
Comments
0 comments
Please sign in to leave a comment.