TRANSFORM TABLE MANIPULATION

KNIME Analytics Platform
1

Good afternoon Team, how are you?

I own 3 tables, as below:

table 1

ORIGEM DESTINO 8/11/2023 8/12/2023 8/13/2023
a b 2.165 2.282 2.436

table 2
ORIGEM DESTINO 8/12/2023 8/13/2023 8/14/2023
a b 2.465 2.382 2.736

table 3
ORIGEM DESTINO 8/14/2023 8/15/2023 8/16/2023
a b 2.365 2.482 3.236

I would like to generate a table that, if the date was repeated, it would consider the most recent value, considering that table 1 is the oldest and table 3 is the newest, like the example below.

ORIGEM DESTINO 8/11/2023 8/12/2023 8/13/2023 8/14/2023 8/15/2023 8/16/2023
a b 2.165 2.465 2.382 2.365 2.482 3.236

Thanks

2

Could you please provide the data in tables rather than as text in your post?

3

I think this is a duplicate of this…

1 Like