Hi,
Sorry if this subject has already been treated, but I can't fin it.
I have 2 tables, they have 2 identical column, the third is different. They don't have the same number of rows. I'd like to make a "union" using the common columns, add the different columns and get all the data in one table.
So I use the "union" node and select the common columns, but it doesn't work as I wish. I think, the easiest way to explain the result is an example.
Table1:
id | smile | ic50 |
mol1 | c1ccccc1 | 258 |
mol2 | c1ccncc1 | 123 |
mol3 | ccocc | 987 |
Table2:
id | smile | origin |
mol1 | c1ccccc1 | extern |
mol2 | c1ccncc1 | intern |
mol4 | C1CCCCC1 | extern |
mol5 | ch4 | intern |
Result:
id | smile | ic50 | origin |
mol1 | c1ccccc1 | 258 | extern |
mol2 | c1ccncc1 | 123 | intern |
mol3 | ccocc | 987 | ? |
? | ? | ? | extern |
? | ? | ? | intern |
My expectation:
id | smile | ic50 | origin |
mol1 | c1ccccc1 | 258 | extern |
mol2 | c1ccncc1 | 123 | intern |
mol3 | ccocc | 987 | ? |
mol4 | C1CCCCC1 | ? | extern |
mol5 | ch4 | ? | intern |
I hope it's clear. I don't see any other solution.
Thanks for your help
Nico