Skip to main content
Hi FME community,

 

 

I am trying to build a custom transformer whose settings are controlled by an external (Excel) dataset. For this purpose, I want to add an Excel-reader that provides the values for the individual attributes. However, the columns of the Excel file are treated as attributes instead of parameters. Is it somehow possible to interpret the attributes of the Excel Reader as individual parameters? The solution with a seperate workbench containing a workspace runner (who has the Excel Reader as an input) works but is rather cumbersome.

 

 

Greetings,

 

André
Hi Andre,

 

 

Feature attributes such as Excel column values cannot be treated as user parameters in the Main workflow anyway, but you can pass the attribute values to a custom transformer through published parameters defined in the Custom Transformer.

 

In the custom transformer, once add a transformer containing a parameter with a preferable type (can accept attribute value) temporarily, and create a published parameter from the transformer parameter.

 

Just be aware that the parameter will be deleted automatically if you deleted the temporary transformer before referring to it from the parameter of a non-temporary transformer.

 

 

Takashi
Hi Takashi,

 

 

Thank you for your answer. I am not sure if I understood you correctly but this means there is no way (without a second workbench containing a WorkspaceRunner) to set the parameters of a custom transformer directly by using an external Excel dataset?

 


I mean that the attribute values which have been read by the Excel reader can be passed to a custom transformer through its parameters (published parameters of the custom transformer), if you defined the parameters in the custom transformer definition.

Reply