Set fields to a specific value during a data deployment
When deploying Data, it would be nice to be able to set field values. It could be just to null them or set a value. It could be part of the configuration or data masking.
-
Pankaj commented
I came across this need when doing data deployment configuration specifically for CPQ objects, where we have can only upload in-active consumption schedules as the Consumption rates is child object and deployed later and CPQ validates that Consumption schedules cannot be active without related Rates. Here I thought while data migration if I could select the IsActive fields value to false, that would save me 2 manual operations.
I expected that to be possible using Data Masking, but unfortunately we cannot specify values in Data masking.
Again quite useful feature for a proper ETL tool.
-
Mike Schulman commented
Big +1 on this as well as Daniel's comment. Would be great to be able to fine-tune data masking. For example, set ranges for integers or Char length for text/strings. Creating test data, as opposed to just masking existing data (where values are present) would be a big win.
-
Chris Deutschmann commented
I add my vote to this. We have a number of use cases where we would like to specify values into fields for testing and also to possibly clear out fields that we know will fail e.g. the field is a picklist and some records might have inactive values, so clearing or selecting a standard value would be useful
-
Daniel Grabowski commented
+1 on this!
It would be great to be able to specify values or patterns while masking data. Similar to the "Levels of Masking" feature of Salesforce Data Mask: https://help.salesforce.com/articleView?id=data_mask_masking_types.htm&type=5
-
John F. commented
Being able to set a fields to a specific value when seeding sandboxes would be most helpful . . . Our use case is to be able to set all contact/lead/custom object email fields to a test email address.