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
| Type | Description | Related Article | Available on |
| Fixed | A fixed value is added to all rows | Fixed Custom Value | Plus, Advanced |
| Dynamic | A custom value that varies based on a set of conditions | Dynamic Custom Value | Plus, Advanced |
| Transform Date | Transform a date field in a Data Extension or Data View | Transform Date Custom Value | Plus, Advanced |
| Timestamp | Add the timestamp of when the Selection runs | Timestamp Custom Value | Plus, Advanced |
| Date Difference | Calculate the difference between 2 date fields | Date Difference Custom Value | Plus, Advanced |
| Row Number | Create a new subsequent row number | Row Number Custom Value | Plus, Advanced |
| Apply any function (SQL) | Use as many SQL functions as needed | Apply any function (SQL) Custom Value | Advanced |
| Aggregation | Calculate an aggregated value using Count, Sum, Average, Minimum, or Maximum | Aggregation Custom Value | Plus, Advanced |
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.
Comments
0 comments
Please sign in to leave a comment.