I’m trying to read multiple CSVs from a folder having their file name as one of the columns, I used this method https://www.knime.com/nodeguide/control-structures/loops/example-for-reading-a-list-of-files using that I could successfully read all the files which is amazing but I’m struggling to collect the names of the files as an extra column in the table from which the data is coming.
If I have 2 files named Table1 and Table2,
I want my resultant table to look like this
Column1 Column2 ColumnOfFileName
a x Table1
b y Table1
c p Table2
d q Table2