Hi guys,
I'm using KNIME to manipulate data from a database and I'm attaching them to an .xlsx file in which I have created a report that I convert to a .pdf and I share by email.
My problem is that I would like to automate this process and maybe the reporting nodes may help me, but I don't know how.
For now the .xlsx file is created automatically (with a .bat file), so the only thing that I'm doing manually is:
1) Export it into a .pdf
2) Attaching one table of the .xlsx file into the body of an email
I don't know how to solve this two problems so I'm thinking to create a new report using "Data to Report" nodes.
Does somebody can tell me if in this wai it is possible to
1) add a part of the KNIME Report into the body of an email?
2) attach the KNIME Report to an email?
Many thanks for your help.
Cheers