new CSV Reader get filenames in Files in folder mode

[MaingauAlex]

Hi,

i´m using the newCSV Reader node with files in folder mode.
Is there a way to get the file names as a column?
Or do i have to use the “old way” with List Files node/looping/table row to variable/Url to file path…

Thanks in advance,
Alex

[Mark_Ortmann]

We’ll add that feature with the upcoming release hopefully.

Best
Mark

[erik_pinter]

Great, that would be a VERY helpful addition to otherwise GREAT new file-handling nodes!

[rernenputsch]

Any update on this?
Looking for exactly the same functionality.

[tobias.koetter]

Hello rernenputsch,
we are aware that this is a much sought feature and will add it with the next feature release in summer.
Bye
Tobias

[andrejz]

Hi @tobias.koetter ,

Please consider to add this feature also to the Excel reader node.

Thank you

[tobias.koetter]

Hello andrejz,
yes, we will add this feature to the Excel Reader and all other new file handling nodes that support the files in folder option and that return a data table.
Bye
Tobias

[ipazin]

Hello @MaingauAlex, @erik_pinter, @andrejz, @rernenputsch and all others,

happy to say that with new KNIME version 4.4.0 there is option to add file identifier when reading multiple files with Files in folder option. Now all reader nodes from new file handling framework have a new option Append path column in their Advanced Setting tab (if they have one, otherwise it should be in the (main) Settings tab) which appends path column with the provided name to the output table. This column contains for each row path to file which it was read from. You can further manipulate paths by using Path to String (or Path to URI) node followed by URL to File Path node or one can use Column Expressions node which now (from v4.4) supports Path column types as well.

Give it a try and if any questions/comments don’t hesitate to ask/write!

Br,
Ivan