iam looking for a node (method) to join two tables.
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.
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
I just wanted to point you to the Table Validator (Reference) node.
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.