Row count does not match ...

[adambc]

I have created 2 Connections to 2 tables in their own Workbooks - both tables have an Email Address column ...

Table1 has 233 rows, Table2 has 777 rows - there are no duplicate Email Addresses in either table ...

I have then created 2 Merge Querys using the Email Address columns and Fuzzy matching set to Ignore case ...

Merge1 is Table1 to Table2, Merge2 is Table2 to Table1 ...

Merge1 shows "233 rows loaded", but Merge2 shows "774 rows loaded" ...

I was expecting Merge2 to show "777 rows loaded" ie match against all rows in Table2 against Table1 ...

Any thoughts on why I get this discrepancy - and how to track it down?

Many thanks ...

 

[RoryA]

Presumably you have items in Table2 that don't match anything in Table1, even with fuzzy matching. If you only want to see the items that didn't match, use an Anti join.

 

[adambc]

Presumably you have items in Table2 that don't match anything in Table1, even with fuzzy matching. If you only want to see the items that didn't match, use an Anti join.

@RoryA

Thanks for the Reply ...

Yes, but I was expecting all from Table2, with matching from Table1, but I'm 3 rows short!!!

 

[RoryA]

Yes, but I was expecting all from Table2, with matching from Table1, but I'm 3 rows short!!!

What kind of join did you use?