Skip to main content
Best Answer

dropdown list on Output Attribute name in AttributeManager

  • November 7, 2025
  • 1 reply
  • 76 views

franco69
Contributor
Forum|alt.badge.img+10

Hi guys,
how can i handle to read in Excel sheets (with other column names from time to time) and have the possibility to choose from a schema (xls) the right attribute names for the workflow…..

Parameters on the reader?

I’ve tried the Attributemanager and import a excel file...but the names from the excel sheet are only added to the default output attribute names

 

a dropdown list on the Output Attribute name would be great……..any help to handle it or a link to another article

Greetz and thanks
Franco

Best answer by jamatsafe

Hi ​@franco69 ,

If I am understanding your question correctly, you're working with Excel sheets where column names change from time to time and you would like your workflow to adapt automatically? Please correct me if I’ve misunderstood!

The functionality you're looking for may be related to dynamic workflows, schema mapping, and/or user parameters. When generating a workspace (Ctrl+G), select 'Dynamic Schema' in the workflow options to add dynamic readers and writers into a basic dynamic workspace to support schema changes. Keep in mind, if you modify attributes mid-workflow (eg. AttributeManager), you may also need a SchemaScanner to retrieve the updated schema before continuing.

Dynamic workflows can get tricky, so I'd recommend starting with the Schema tutorial series. Topics like Schema Drift and SchemaMapper (map varying input attributes to consistent ones) may be especially relevant to your use case. In addition, there are 3 modules in the FME Academy Form Advanced course that also serves as a good general introduction:

Hope this helps point you in the right direction!

1 reply

jamatsafe
Safer
Forum|alt.badge.img+11
  • Safer
  • Best Answer
  • November 14, 2025

Hi ​@franco69 ,

If I am understanding your question correctly, you're working with Excel sheets where column names change from time to time and you would like your workflow to adapt automatically? Please correct me if I’ve misunderstood!

The functionality you're looking for may be related to dynamic workflows, schema mapping, and/or user parameters. When generating a workspace (Ctrl+G), select 'Dynamic Schema' in the workflow options to add dynamic readers and writers into a basic dynamic workspace to support schema changes. Keep in mind, if you modify attributes mid-workflow (eg. AttributeManager), you may also need a SchemaScanner to retrieve the updated schema before continuing.

Dynamic workflows can get tricky, so I'd recommend starting with the Schema tutorial series. Topics like Schema Drift and SchemaMapper (map varying input attributes to consistent ones) may be especially relevant to your use case. In addition, there are 3 modules in the FME Academy Form Advanced course that also serves as a good general introduction:

Hope this helps point you in the right direction!