Concatenate multiple tables with source indicator

KNIME Analytics Platform
1

Hi I want to concatenate multiple same tables from different postgresql databases
I Successfully that with Concatenate (Optional In)
I need to add extra column to target table which is contains source database name (or any other indicator).
Is there any way to do that?

2

If you precede the inputs to the Concatenate node with

(one per input) then you can add a column with whatever constant value you choose

Steve

4 Likes
3

Thanks Steve for quick response.
It helped.

Regards,
Noyan

2 Likes