Merge table

[Charmaine]

Hello all,

I tried to merge two tables. I have checked with excel, all rows should match but the result is only 13 out of 5500 matched. 

I have adjusted privacy level and data type, still cannot make it.

One table is from SQL server and another one is from Excel in Sharepoint

I guess this is some technical problem, do you have any idea to fix this?

Thanks ..

[Greg_Deckler]

Make sure that you Trim and Clean your data columns and if they are text, make sure you do something like proper case or convert to all upper case or lower case. Sample data would help.