Multiplying multiple columns with different columns in a table
Hi Everyone,
I have a table with columns like Var1, Var2, Var3…Var10 and I also have some value in columns like Var1coeff, Var2coeff,Var3coeff…Var10coeff. I want to multiply and creates columns like FinalVar1, Final Var2…FinalVar 10 by multiplying corresponding columns
FOr. e.g.,
FinalVar1 = Var1 x Var1coeff
Finalvar2 = Var2 x Var2coeff
…
…
Finalvar10 - Var10 x Var10Coeff.
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.
Thanks