This thread is for posting solutions to “Just KNIME It!” Challenge 32. Having a clear table structure is important… that’s why we’re cleaning up our Excel sheets this week!
Here is the challenge:
Just KNIME It!
Feel free to link your solution from
KNIME Hub as well!
And as always, if you have an idea for a challenge we’d love to hear it!
Tell us all about it here .
Be aware, season 1 of “Just KNIME It!” slowly comes to an end… Until October 26!
here is my solution:
7 nodes: it ain’t much but it’s honest work
Have a nice evening,
My Solution for Challenge 32
Done in 5 nodes
Typo, should be collate horizontally
Straightforward solution for this challenge ! I can’t think of another way to solve this without using other than base nodes
Here’s my solution. I used a component to create the headers.
here is my solution.
No loops just sort, rank and pivot. 6 nodes, 2 for I/O
Hi, here’s my solution by using my final weapon Creat Collection Column.
My Take on the Challenge 32- Split is straight forward by chunk …Tried to take group loop instead and column append end … Missed the 3 dots divider though.
As always on Tuesdays, here’s the solution for last week’s # challenge! We hope you like our use of the Loop nodes as a way of grouping and concatenating rows more easily! justknimeit
See you tomorrow for a new challenge!
So far so good the solution is simple. But how can I implement the solution without deleting the Excel formatting? Let’s imagine I have a huge Excel file with complex formatting. Then a single KNIME node shatters my whole Excel formatting, which is very annoying. Therefore the question, how can I find a solution without destroying the Excel formatting? After all, the template Excel file already had formatting, which is now gone. I am looking forward to a “simple” and “workable” solution without the Excel formatting nodes. Thanks
Here is a post about keeping excel formatting:
@helpmeplease if you want the structure of your Excel file unchanged and just change values there are these options, if you must change data on a pre-formatted sheet (otherwise you might just replace this sheet). The Excel Cell Updater can change values in specific cells.
You can use a community node to write to an Excel file without changing the structure or formats:
You can the use Python and OpenPyxl to do more complex editings of excel files. You will have to plan ahead what this d…
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.