How can I delete unwanted fields from a detail table?
I have removed the fields from the data mapper extract step and removed all reference to them from the template.
The delete option is always grayed-out
Closing and reopening the designer doesn’t help.
The fields are “required” (which is indicated by the asterisk * next to their name). So either you specifically marked them as required, or more likely, you imported the Data Model from another file, in which case all fields are automatically marked as required. Just right-click on each field and remove the required attribute, that should allow you to delete them (and actually, if you’ve already removed the extraction step, removing the required attribute will automatically make the field disappear from the data model).
Thanks Phil, that worked fine.