Apply any function (SQL) Custom Value
This feature is available on Unaric Segment Advanced.
Apply 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 to either code from scratch or copy-paste existing queries applied in the SELECT clause to generate new values as necessary.
Only SQL functions applied in the SELECT clause work. Queries with a FROM/WHERE statement or that require other statements after the SELECT clause (e.g. a GROUP BY) won't work.
To learn how to use the Apply any function (SQL) Custom Value to get the First Name of your Contacts in Camel Case for your email campaign, see 28. Get a Contact's First Name in Camel Case.
Video overview
Create an Apply any function (SQL) Custom Value
- Under Custom Values, click the Add new value button.
- Provide a name for the Custom Value, select Apply formula to a field as Type of Custom Value, and click Next.
- Select Apply any function as Type of Formula and click Next.
- Select the type of value that you want to populate and use the board to write your query.
- Optionally, you can use the suggested functions via the Insert Function dropdown and clicking 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 and click Insert Field.
- Click Check syntax to validate the query and click Save
- You can now move the new Custom Value over the Target Data Extension fields.