I am facing a problem I cannot see any way to solve.
I have a joined table where I have create the sum of column pairs.
The pairs are the columns with the same index from both table, let’say I joined two 3 columns-table, then I need the sum of the columns of 1,4, 2,5 and 3,6 columns.
How could I perform these operations if I don’t how many columns will I have?
are names of columns 1,4; 2,5 and 3,6 and so on somehow related? If same or similar you can modify this approach where I compared two tables column vs column:
If column names are not same you can use Extract Column Header node on both tables before joining to make them same and then use above approach.
Thanks a lot for your help
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.