Data aggregation across multiple Sharepoint files in KNIME 4.2

[ipazin]

Hello @longoka,

just to drop info in case you haven’t seen it that with new KNIME version 4.4.0 you can can distinguish which rows in the final aggregated data frame come from which source file by adding path column. See here for more:

new CSV Reader get filenames in Files in folder mode

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 …

Br,
Ivan