How do I do a full join in gnumeric?

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

How do I do a full join in gnumeric?

GnuMeric mailing list
I often encounter such a problem. There are two tables sharing the same
key ID, but they do have different num of records. But some of records
do not appear in another table. I need to merge them into a whole table
with all fileds where the missing values are replaced by blank or N/A.

For exmaple

table1
======
ID Name
1 Andy
2 Jack

table2
======
ID Phone
1 111
3 333

||
||
VV

merged_table
============
ID Name Phone
1 Andy 111
2 Jack
3 333

BTW, Excel provides SQL support, so I thought I could use FULL OUTER
JOIN Syntax[1] to do this.

[1] FULL OUTER JOIN Syntax: https://www.w3schools.com/sql/sql_join_full.asp

_______________________________________________
gnumeric-list mailing list
[hidden email]
https://mail.gnome.org/mailman/listinfo/gnumeric-list