keyur

keyur

  • NA
  • 363
  • 0

DataSet Problem

Feb 23 2015 12:21 AM
Hello


I have two dataset. there are more then 10k rows in both dataset.


Now I have to compare both dataset with multiple keys (Composite key) and find the differ rows based on that.


Means,
Dataset1 have County,State,ID,Address,PostalCode
Dataset2 have County,State,ID,Address,PostalCode


I have to compare with ID,County multiple key and find different and new rows


Can you give idea to do this? 

I do not want loop each row which already hang the system

Thanks
Keyur




Answers (5)