Hi all,
I’m new to the world of Knime. I’m trying to read an excel file with 10 cells and convert it to a document. I inserted an excel reader followed by a GroupBy node and a Strings To Document but as soon as I go to see the output of the node the document part is empty
Hi @rizzo_antonio
I’m not sure what is your expected output, however just as an example I have connected String to Document node directly to Excel Reader node.
Both nodes have been executed and I’m able to view the outcome of Strings To Document node.
Could you please specify your expectations?
Please note what I’m sharing is just a graphic, not w workflow.
Regards,
Kaz
Hi, thank you for your reply. Attached my example workflow
EXcel data read.knwf (11.9 KB)
What I’m expecting is to have in Document column some data and not an empty value as it is now.
Thnak you
@rizzo_antonio please share excel file with input data. Excel Reader refers to file on your OneDrive
E033.xlsx (9.9 KB)
Ok, it’s attached. This is only an example but my overall data are in this format.
Antonio
I’m still not sure if this is something you are looking for, but please have a look:
-
Just two nodes: Excel Reader and String to Document
-
String to Document configuration
-
Outcome after execution
I’m also quite new to KNIME, thus started with the simplest solution.
Thank you very much it works.
Antonio
Happy to hear that, happy KNIMEing Antonio
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.