Merge multiple tables

KNIME Analytics Platform
#1

Hi All,

I am new to KNIME and learning great. I have a use to merge multiple tables. Every table has different kind of data but BP ID is same in every table (but some table have more BP IDs and some are less). The below is sample…

Table A

BPID -  Cost – Profit

0001 – 10 -4

0002 -11 - 3

 

Table B

BPID - Name – Address

0003 – John - Dallas

0002 –Mark - Huston

 

Table C

BPID – Zip code – State

0004- 74001 – TX

0002-75008 – TX

Output (after merging in Table A+B+C) would be like this…

BPID – Cost – Profit – Name – Address- Zip Code – State

0001 -10-      4      -    NULL      -- NULL – NULL – NULL

0002 – 11 – 3      -     Mark -   Huston ---75008 – TX

0003 – NULL – NULL – John – Dallas – NULL – NULL

0004 – NULL – NULL – NULL – NULL – 75008 – TX

 

Thanks for your help in this.

#2

I would assume using a join node using full outer join mode with table A and table B to start with. And then take this output and do a full outer join with another join node with table C would give the desired output.

simon.

#3

Thank you very much for your help. If I want to add more tables, is it I need to join table after table? please advise.

#4

You could potentially do this using loop start and end nodes, but otherwise it will be using multiple join nodes. 

Simon.