What is the coalese value for the transform map? The create action will create a record on the table that holds the value of that field. If the cost center field is a reference field, then a record will be created with the value that is coming back. Is the field a string field or a reference field?
In this example there is only one cost center that many users can be part of. Similar to many users being in the same location. It's a one to many relationship which is the expected behavior.
