Add Excel file name while reading multiple files with "Include subfolders” option

[mauuuuu5]

Hi everyone, I am trying to add the excel file names as a new constant value (along with the file data) when using the “Include subfolders” option in the Excel Reader

I know that there are other examples, but I wonder if there is a more recent approach using the Excel Reader node.

Thank you

[iCFO]

If you include sub folders, then you would use the “filter options” to pinpoint specific file names. You can’t point the node directly to multiple full file paths. However, you can alternatively bring in multiple full file paths as flow variables if you are unable to make the filter options work.

[mauuuuu5]

Hi thank you, I just came up with a similar solution as mentioned above.

Multiple Files add Name.knwf (40.8 KB)

Regards

[ipazin]

Hello @mauuuuu5,

in Excel Reader under Advanced Settings tab there is option Append path column. Using Column Expressions you can then extract file name. With this approach you simplify workflow design and avoid loop.

Br,
Ivan