Combine two tables

Hello,

iam looking for a node (method) to join two tables.

Example

Table 1:

A B C D E
? ? ? ? ?

A D G H
1 1 1 1

The result should be look like

A B C D E F
1 ? ? 1 ? ?

I tried the joiner with several configurations, but i failed.

What I wanna do is to find out if two different tables have common columns.

Hi!

I guess your tables are transposed.

In that case use Join node with option Full Outer Join and joining column should be your letter column. First column you will get is your letter column where you should filter row if there is missing value (Row Filter node). In your case 2 rows will be filtered. Then use Rule engine node with following Rules:

MISSING $Value (#1)$ => $Value$
TRUE => $Value (#1)$

If you got missing value in Table 2 take Value from Table 1. Else take value from Table 2.

Not sure were you got the letter F because it is not in both of your tables :slight_smile:

Br,
Ivan

2 Likes

Hi @Nemies

I just wanted to point you to the Table Validator (Reference) node.

https://hub.knime.com/knime/nodes/Table_Validator_Reference*Y4pjF_CT2oL_sTHE

It was made too compare too tables and ensure the first one has the same as the second one. Maybe it is helpful in your case as well.

Cheers, Iris

2 Likes