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