When creating a DataTable in daSchema with a Target Table defined and extra Left Join fields, some strange things happen with the mappings. In the Database Table Fields some fields are used multiple times to map the extra joined schema table fields (see screenshots). Are we doing something wrong?
This is expected behavior. Schema Modeler doesn’t know which exactly DB fields to map to these extra schema fields. Anyway you have to set these mappings manually in this case.
Doesn’t it make more sense to leave the mappings empty if no field is found in the DB Fields. Because now wrong fields are mapped. And if we have 50 extra joined fields, we have to manually clear all the wrong mappings.
We have no concrete ETA for the next stable release, but it should be after the official VS 2017 release (for obvious reasons - we need to make sure that our IDE integration code works there)