I have an Excel file that contains some lookup values. I had to edit the Excel file and add some additional columns. How do you get the lookup to see the additional columns? I have closed and restarted the transformation as well as the application. I am at a loss how to get it to refresh to see more than the initial 12 columns.
It would also be nice if the interaction with Excel could work with Excel Tables.
