Records that Have Changed

[#1]

Hi Everyone,

I have Outlook contacts which I export as a csv.

I have the same records in another csv which will contain updates to Company, Role, Address etc.

My challenge is to create a table with only the change records so I can upload back into Outlook.

Delving further into the data;

Outlook

First Name          Last Name               Company          Role                         City         

Rob                    Webb                     ABC                 Qlikview Developer       New York

John                    Brown                    XYZ                 Qlikview Developer       New York                        

New File

First Name          Last Name               Company          Role                         City         

Rob                    Webb                     CAD                 Qlikview Manager        New York    

John                    Brown                    XYZ                 Qlikview Developer       New York         

Outlook is always the file that will always change (New File is always Master).

First Name, Last Name should not change (however that's not guaranteed (marriage)).

My output would be the change records only.

First Name          Last Name               Company          Role                         City         

Rob                    Webb                     CAD                 Qlikview Manager        New York    

Would anyone be able to help me out with this challenge please.

The caveat is that each file is around 10,000 records hence the search for a 'smarter' way of doing this.

Thanks,

Rob

[Gysbert_Wassenaar]

Something like this perhaps:

FirstCSV:

load *, autonumberhash256([First Name], [Last Name], Company, Role, City) as Key

from ...sourcefile1...;

SecondCSV:

noconcatenate

load *, autonumberhash256([First Name], [Last Name], Company, Role, City) as Key

from ...sourcefile2...

where not exists(Key);

Drop table FirstCSV;

Drop field Key;