Records that Have Changed

Wed, 02 Oct 2013 15:12:35 GMT

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

Re: Records that Have Changed

Gysbert_Wassenaar — Wed, 02 Oct 2013 16:06:30 GMT

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;