Solutions to "Just KNIME It!" Challenge 32

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! :broom: :sparkles:

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! :heart_eyes: Tell us all about it here .

Be aware, season 1 of “Just KNIME It!” slowly comes to an end… Until October 26!

2 Likes

Hello Knimers,

here is my solution:

7 nodes: it ain’t much but it’s honest work :joy:

Have a nice evening,
Raffaello

2 Likes

My Solution for Challenge 32

image

Done in 5 nodes

Results:

3 Likes

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 :sweat_smile:

3 Likes

Here’s my solution. I used a component to create the headers.

3 Likes

hi everyone,
here is my solution.
No loops just sort, rank and pivot. 6 nodes, 2 for I/O

3 Likes

Hi everyone,

Here is my attempted solution: justknimeit-32 - Change Structure of an Excel File – KNIME Hub

2 Likes

Hi, here’s my solution by using my final weapon Creat Collection Column. :laughing:

2 Likes

Opps… forgot the link.

2 Likes

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.

2 Likes

Hello everybody! :smiling_face:

:boom: 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! :boom:

See you tomorrow for a new challenge!

1 Like

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:

1 Like