A company wants to include certain personalized fields in an email by including related attributes during the activation in Data Cloud. It notices that some values, such as purchased product names, do not have consistent casing in Marketing Cloud Engagement. For example, purchased product names appear as follows: Jacket, jacket, shoes, SHOES. The company wants to normalize all names to proper case and replace any null values with a default value.
How should a consultant fulfill this requirement within Data Cloud?