Put the file name in a column
I am uploading an excel file to knime, the file is called C:\File 01062024, I would like to create a column with the name of the file, is that possible? For example, when you load in Knime it looks like this.
| Product | Value | File | |
| | | | |
| X | 10 | C:\File 01062024 | |
| Y | 20 | C:\File 01062024 | |
| Z | 30 | C:\File 01062024 | |
| | | | |
| | | | |It is possible that when the Excel is loaded, you can add that column with its name, another question that happens if there are multiple files that have the same structure and I would like them to be loaded in a single table but with a column that has the name of each file