Updating table with dynamic column name in lookup table

KNIME Analytics Platform
1

Hello all,

I have one Table:
ID Work Day
001 Bob 3
002 John 5
003 Leon 1
004 Lima 7
005 Geor 9

I want to change values by using the second table:
ID Work Day
003 Leon 3
005 Uwe 5

I want to receive the next Table:
ID Work Day
001 Bob 3
002 John 5
003 Leon 3
004 Lima 7
005 Uwe 5

But I want to create a flow where a system will do it automatically without considering the column name(column names can be changed, but workflow should be same), for example:
ID Resp Shift
001 Bob 3
002 John 5

should be updated by:

ID Resp Shift
001 Bob 1
002 John 5

So, I should do many similar tables, but only first column name is constant- “ID”, but others can be different.
Thank you!

2

@IMR2KA maybe you can check out this example and adapt it to your needs:

3

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