Add download URL as new column

[erisu]

Hi All

I would like to add Sharepoint URL in imported data (to identify data from which folder).
Does anybody know how to manage this?

Thank you!

[ipazin]

Hello @erisu,

what KNIME version are you using?

Whit new file handling framework there is no need to download data locally in order to read it into KNIME. So after source connection is created you can feed connection to Reader node if no loop is need or to List Files/Folder node followed by a loop. Read here more about it:
https://docs.knime.com/latest/analytics_platform_file_handling_guide/index.html#introduction

Also see here about possibility of adding path as a new column when reading data:

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

[Daniel_Weikert]

Just to add,
a constant value column can also be used to write a path(flow variable) as a table column
br

[erisu]

Thank you .It worked !

[Daniel_Weikert]

Great work @erisu
thanks for your feedback and marking the solution so other can find it later as well
br and take care