Hi Knimers,
I have a table with one column named ‘url’ that contains url link and a second column named ‘title’ that contains the article name. I want to combine them in the following format so that I can export a csv file with hyperlinks.
I thought I could use a string manipulator to achieve this task but I don’t seem to get it correct. It might be very simple but I am unable to find a path. Any ideas on how to combine these columns with the specified format?
I also manually created a table as an example to show what I want to export. Please see the attached work flow.
Any help and suggestions are appreciated. Thanks a lot.
Hi,
Out of the box KNIME does not support adding formulas to Excel files. This is what I assume you want to do, since you are using =HYPERLINK. A community member has shared a solution for this, though. It is not super-straight-forward, but maybe helps: KNIME - openpyxl and xlsxwriter to add formulas to excel files – KNIME Community Hub.
Kind regards,
Alexander
Hi, @AlexanderFillbrunn, Thanks for the reply and suggestion I wanted to create an Excel or CSV that contains the title with a hyperlink.
Actually, after some struggle, I found a way. It seems column expression node is a simple way to achieve this goal.
I am including this very short workflow in case someone else looking to perform a similar task. URL link csv file.knwf (31.6 KB)
I wanted to create an Excel or CSV that contains the title with a hyperlink.