I have a bunch of Excel files I need to merge. They are all formatted similarly, so I have been able to successfully merge the files using the Excel Reader and Excel Writer nodes. I am very new to Knime, so where I am struggling is adding the file name of each file to the merged data file so for each row I know what company is tied to that data.
Any thoughts on what workflows I should consider to facilitate this?
My file names look something like this:
CompanyName - 47d947f4-cc79-4dd1-8e57-587ce07ae0a8_Q26.xlsx
You shouldn’t need such a complicated script to just get the filename as you originally described. In the Excel Reader node, navigate to the Advanced Settings page and enable the option to add a Path Column.