do you know this feeling when you think “I have done this before, but how does it work again?”…
I have that now with the following challenge:
I have a table resulting of a GroupBy Node and now want to have the column content added to the same row, as this is somehow how the - already existing - results spreadsheet (Excel) is set up since ages.
This is what I mean.
Here’s my input table:
The result spreadhseet (should) look(s) like this:
I have tried with Transpose and Unpivot Nodes but somehow couldn’t quite get there. Also tried the Lag Column Node but it somehow skipped some content.
I have shared the input workflow over at the KNIME Hub - it also included the results table as a spreadsheet file in the KNIME workflow’s data area (shared with the wf).
What makes one to straggle here is that amazingly, the operation needed is a combination of unpivoting and transposing. It is not as obvious as it seems
The situation we’re faced with is this: We want to use KNIME to automate the nasty formula copy & paste stuff. So what is a Table Creator Node in this very example is the result of a bigger workflow in a real world use case (can’t share due to restrictive information). This question was more geared towards the question “how do we get this back into Excel?”
Why “back to Excel”? The thing is, we currently cannot force them into using KNIME but instead automate with “what we have”, hence the spreadsheet they need to use.
If we combine this with the Excel Cell Updater Node, we would basically have an end-to-end ETL / spreadsheet automation workflow.
I understand that @kowisoft. Don’t have an issue with getting data back to Excel file and having work automated. Just saying that using KNIME to prepare Excel format (not data!) is cumbersome and there should be an easier way if there’s no one.
Ivan