Hello to everyone!
Do you know how to make table like Table3, using data from Table1 and Table2?
I think about node Joiner node (join by ID) and “StringManipulation (Multicolumn)” node.
But nothing worked
You might consider using the column rename node first and then a join based on the ID.
I join two tables using the Joiner node and add a suffix for the right table, but I need a dynamic formula for the result table (Table3), that will calculate the difference between identically named columns.
Hi @greatvarona , this is a simple table attachment task (+ math calculation). I’m sure if you upload your workflow here, @knimediger or somebody else can start working on it real fast. Best of luck!
Please check whether the attached workflow helps your need.
Sample For Testing.knwf (31.8 KB)
Regards,
Prem Kumar R
2 Likes
Is a python script an option?
If not I assume the solution involves a loop with column rename regex and then a math formula subtracting the renamed columns, and rename them back. Some of the sophisticated members here have built something similar in the past if I remember correctly.
br
1 Like
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.