I have an Excel Reader and several transformers that follow. I would like the attributes to update when I select a new .xlsx file. Most attributes should be the same but on occasion a file is submitted with one of the column names a little bit different. I was hoping that I would just have to re-connect those. What I have been experiencing is that I have to Update the Reader and then my AttributeManager transformers have to be completely rebuilt.
Example:
First Run - Fieldnames are CITY, STATE, ZIP
Second Run - Fieldnames are MY CITY, STATE, ZIPCODE
Is there an easy way to handle this?