work with dynamically changing tables

KNIME Analytics Platform
1

Hi everyone
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?

Thanks

2

Hello @HarryKl,

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.

Br,
Ivan

3 Likes
3

Thanks a lot for your help

1 Like
4

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.