I am importing new records onto a table using an import set/transform map. We have 3 instances - Prod, Dev and Test. With what I have setup, I can import these, however, so far I have only imported changes to existing records that have associated Numbers. Right now, I want to import new data where the coalesce field (the Number field) are empty since they are not yet in the table. I have the checkbox checked to create new records if the coalesce field is empty, but I am curious - I want these associated Numbers with each new record to align/be the same in each instance. How do I guarantee that will happen when importing? There are inconsistencies between the records on each instance (Prod has the true amount, Dev has 6 additional records, Test has 3 additional records). What is best practice for this scenario?
