Fix: Merged table has empty rows

When you merge two tables, there may be rows they don't have in common. This can create the appearance of missing data or empty rows. Here's what happens with some common merge situations in Fusion Tables.

Let's say our first table has country populations:

Country	Population
Argentina	40,764,561
Brazil	195,655,014
Denmark	5,574,000

Here's a second table with the country's official language: 

Name	Official Language
Argentina	Spanish
Canada	French, English
denmark	Danish

Now merge these two tables using the "Country" and "Name" columns. In Fusion Tables, the first table dictates what rows appear in the merged table. (Database buffs will recognize this as a left-outer join.) 

Here's the result: 

Country	Population	Official Language
Argentina	40,764,561	Spanish
Brazil	195,655,014
Denmark	5,574,000	Danish

Notice a few things missing? 

The second table didn't have a row for Brazil, so the new column is empty. 

Although the second table had a row for Canada, the first didn't, so Canada doesn't appear in the merged table. (If having Canada is more important to you, try starting the merge from the second table.)

Both tables have a row for Denmark, although one is lowercase. Because the merge ignores case when matching strings, it succeeds in matching "Denmark" with "denmark".