I have a very simple workflow setup:
- read a table (typically either a .CSV or Excel file) which then connects to
- an Attribute Manager set up with multiple fields from a template that adds and renames them so they can be seamlessly imported into another database with exactly the same field names; and then this connects to
- Excel Writer (the file format required for import)
Since the files I’m reading into FME Workbench do not have all the fields or match exactly those in the template/Attribute Manager has (the point of the workflow), I get an “incomplete transformer” error message. The workflow executes flawlessly, however, and I’m getting the results I need.
I’m wondering, however, if there is a way to eliminate the error - the red “incomplete transformer” icon in the navigator window is a bit disconcerting. 😉
PS: I have added the following annotation to the AttributeManager should there be no way to get rid of the error message/icon before I share the workflow.
************
ATTRIBUTE MANAGER WARNING (SAFE TO IGNORE)
The AttributeManager defines the full template schema (143 output attributes).
Most incoming datasets will contain only a subset of these fields. Because of this,
FME may show an "Incomplete Transformer" warning during design time.
This occurs because the transformer references attributes that do not exist in the
current Reader schema.
This warning is expected and does NOT affect execution.
Expressions such as:
@Value(NAME)
safely return NULL if the attribute does not exist, allowing the AttributeManager
to create all required template fields even when the input dataset contains only
a few columns.
As long as the workspace runs successfully and the output contains the full
template schema, the warning can be ignored.