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!
Hello Knimers,
here is my solution:
7 nodes: it ain’t much but it’s honest work 
Have a nice evening,
Raffaello
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 
hi everyone,
here is my solution.
No loops just sort, rank and pivot. 6 nodes, 2 for I/O
Hi everyone,
Here is my attempted solution: justknimeit-32 - Change Structure of an Excel File – KNIME Hub
Opps… forgot the link.
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.
Hello everybody! 
As always on Tuesdays, here’s the solution for last week’s #justknimeit challenge! We hope you like our use of the Loop nodes as a way of grouping and concatenating rows more easily!
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
Hi @FlowCreator,
Here is a post about keeping excel formatting:
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
