Thanks again @Kathrin . I am not familiar with the loop and variable nodes in Knime, I guess I have to read more. So far, the only experience I have had with success, doing it on my own without any reference, is when I had to (on another sub-project) add a constant value to the constant value node using a variable. It was a simple task
Anyway, I have copy and pasted my table of 57 columns onto your workflow. To summarize, thanks to your workflow, I finally worked it out. It wasn’t a straightforward solution once I applied my columns though. But I will mark your previous post as the Solution. Really appreciate you helping out.
On another note, I will note down here the problems I encountered and how I worked around it, so that other people who might experience similar issues can refer to and act accordingly:
- I ran the workflow once I applied my columns to the workflow. After the loop runs ended, I checked the results of the math calculation to see if they were correct, and to my surprise they were all positive values, when there should be negative values too. So, I added one more step to the workflow to ensure all raw values were in the form of numbers and not strings (as shown in the screenshot below) by adding a String-to-Number node after the table creator.
- Once I’ve done that, I noticed a difference in the configuration of the Column Rename with that of yours, where yours had the option to choose Integer in the dropdown menu, while mine had the 6 types of menu items as you can see in the photo above. I chose Double Value in the first place, then I ran the workflow and recheck the calculations. The solutions were wrong again. Finally, I changed the option to either ComplexNumber or FuzzyNumber. The workflow was ran again. Finally, everything falls into place.
I don’t understand what I did myself, but hey, the numbers are now correct (finally!).
Thank you again. It saved my time.