Hello, I just started learning KNIME today and I’ve run into an issue with the Excel Reader.
I have a folder with weekly data in excel files and they all have the same table structure. The only difference between all these files is the sheet name since the sheet name changes every time the data is exported from my source (which I have no control over).
Is there a way to get Excel Reader to read all the files without having to manually change the sheet name in every excel file so that they’re all the same? I know I wouldn’t have to worry about that if I had the files in another file format, but I’d like to avoid that since I have years worth of data. My goal is to have these files combined into a single file.
I’ve tried to look at other people’s questions to see if I can get some kind of answer to work with, but nothing seems to help.