I have a table with columns like Var1, Var2, Var3…Var10 and I also have some value in columns like Var1_coeff, Var2_coeff,Var3_coeff…Var10_coeff. I want to multiply and creates columns like Final_Var1, Final Var2…Final_Var 10 by multiplying corresponding columns
FOr. e.g.,
Final_Var1 = Var1 x Var1_coeff
Final_var2 = Var2 x Var2_coeff
…
…
Final_var10 - Var10 x Var10_Coeff.
I can achieve this task using Column loop, rename flow, and R snippet. However, I want your help in if I can do this exercise with existing nodes and in a more natural way.
As far as I understand, Multi Column Math Formula does a single operation on multiple operation. For e.g, if I needed to do single operation with multiple column than that would this node would have been useful.
however, my challenge is to do different operation with different columns. that is where I am struggling.
I tried to set up da workflow where you have a ‘system’ of Variables and Coefficients that are identified by their name “Var1” and and addition of “_coeff” like in your example. The workflow is flexible so that it would take any number of columns of that structure and combine them (multiply in my example). If you know the operation maybe you could also put that in a variable and construct a formula with a simple Java Snippet within the loop.
For the loop I have only found the solution to rename every variable into a standard name, use the Math node and then name it back.
Maybe you could have a look at that and try to expand.
If you have sort of a ‘fixed’ environment of variables and operations you want to do, or it would not change that much it could be an idea to think about a Java Snippet that would do that.
I should look into the quite new multiple math column node if it can handle patterns of columns or one can create flow variables to handle that. Then it could be that the workflows could be simpler and would not require a loop.
Also a Loop or apply in R could be possible. I am not sure how the Java Snippet node would Handel a loop.
