I have read multiple questions\\answers\\commentaries around this topic and I may be more confused than before.
Here is the scenario:
- I have an excel workbook
- The sheet names are always the same
- Some of the columns are static
- Some of the column names change-- and sometimes there are more or less columns
- I need to capture the column names and row values then process the info
- The only way I have seen to update columns is to manually refresh the reader with 'Update Feature Types'
- Is there a way to dynamically read in new or changed excel column names without manual intervention? FME 2021.2
Thanks!