Hi HansS
I just understand what you said, but actually I have total 39 months data need to be sum into 13 Q. If any other node to quickly get the result.
Hi ScottF
Thank you for your kindly help. But actually I have total 39 months data need to be sum into 13 Q. If any other node to quickly get the result.
Whether you go the Column Aggregator or Column Expressions route, I think you will just have to use either multiple nodes or expressions, respectively. There’s not a single node/expression to get the format you need.
Honestly It would have been better if we were able to keep all the Jan values in one column and Feb Values in one column and so on. Then 4Q would have been enough.
I’ve created something more dynamic that will create Qx (Q1, Q2, … Qn) dynamically at every 3 columns, and each of the Q columns contains the sum of the 3 columns, so it does not matter if your table has 3 columns or 39 columns or 300 columns, it will work the same way. It also does not matter what the column names are, it will work the same way.
Hi bruno29a
Thanks for your kindly help and your workflow, I will learn from it.
I am new to Knime. Sorry, I don’t know how to @berserkersap 's post as solution. Would you pls advise.
Hi @Chenfang , I’m not sure how it works for choosing a solution as I have never created a topic/thread, so I’ve not seen the interface for it. But I see that you have figured it out already
Also, just a correcting to my last post for the last demo (39 columns), the results was that it added 13 Q columns, from Q1 to Q13, and not 14 Q columns as I wrote. It was past 1am when I wrote that