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
[email protected]
https://mail.gnome.org/mailman/listinfo/gnumeric-list
