While working with a customer, we have noticed that there are situations where a customer may want to aggregate a null Salesforce field while pushing data to an MDA table.
In a Load to MDA rule, you can set the default value to "0", however when you aggregate a null value, the value remains null regardless of what default value you set. This is because when the aggregation happens, the aggregated value of null is null, and the MDA recognizes that as a value.
What I am proposing is the ability to actually set a default value on the field level when you create a field in the MDA. So for example, if I create a new field in an MDA table called "test 1", I'd like to have a dropdown or checkbox to set a default value in field properties when I create the field itself.
Want to have the ability to set default values on the MDA table itself
Reply
Login to the community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.