Append table while retaining a specific column

[ReynaMain]

Hi! Can you help me with a task? I already know how to append tables when continously exporting files but I need a specific column to follow the values from the first exported file.
Here is an example:

[Thyme]

This is a duplicate of that thread:

How to append column but getting values from previous export

I am having trouble with this: When I export my first file, my column for Username would be filled like this: (1st Export) Username Tester1 Tester2 Tester3 When I export a second file (which will only append from the 1st export) and the column value for Username is changed, I want the output to be from the 1st export. (2nd Export) Username Tester A Tester B Tester C Expected output would still be (note that I only want this to work on this specific column) Username Tester1 --1…

Please keep the forum tidy by not scattering one question over multiple threads

[ReynaMain]

sorry, i’ll delete the other thread. this is more clear than the last one

[ipazin]

Hello @ReynaMain,

there’s no built-in logic for such “concatenation” in KNIME writer nodes. You can read 1st export in KNIME, replace User A with User1, User B with User2… and then do export.

Br,
Ivan

[Thyme]

You can use the Joiner to “overwrite” the usernames and then concatenate the tables:

Append table while retaining a specific column.knwf (22.3 KB)