In DESelect Segment, you can create new fields or columns that do not come from any Data Extension to enrich your data. These fields are called Custom Values.
Types of Custom Values
|A fixed value is added to all rows
|Fixed Custom Value
|A custom value that varies based on a set of conditions
|Dynamic Custom Value
|Transform a date field in a Data Extension or Data View
|Transform Date Custom Value
|Add the timestamp of when the Selection runs
|Timestamp Custom Value
|Calculate the difference between 2 date fields
|Date Difference Custom Value
|Create a new subsequent row number
|Row Number Custom Value
|Apply any function (SQL)
|Use as many SQL functions as needed
|Apply any function (SQL) Custom Value
|Calculate an aggregated value using Count, Sum, Average, Minimum, or Maximum
|Aggregation Custom Value
Where to find Custom Value?
- Go to the Target Definition screen.
- Under the Available Fields section, you’ll find the Custom Values section.
- Click Add new value to create new Custom Values.
You can also create reusable Custom Values. Follow this link to learn how to create reusable Custom Values.