How to write big excel data with help of loop function?

KNIME Analytics Platform
2

Hi @GD3F2UV,

welcome to the Knime community. Thinking about this insteresting scenario I felt a generic and flexible solution would be best to provide. Also, thinking about some details liek file path separator, selcting a file etc., an interactive view would add a lot of comfort.

That being said, et voilá:

image
image1804×788 77.3 KB

Here is the solution:

I also thought about the ability to scan the Excel, select a sheet or even dynamically process an entire Excels contents but, looking at the clock, I opted to join my wife instead.

PS: If that solution works for you, please mark this post as the solution.

Best, Mike
CTO @ DataNautics GmbH - Your KNIME-Experts
Contact: info@datanautics.gmbh // datanautics.gmbh // +49(0)170-325 713 9 // Linkedin
Daten Automatisierung für Finanz-, Produktion-, IT- und Marketing-Prozesse mit KNIME

1 Like