I've got a simple problem that I'm having a hard time getting my head around.
I have two sets of data (2 files). File 1 is my master file of a couple of hundred thousand addresses. File 1 is a file of addresses of houses which have specific characteristics.
Quite simply, I want to add a field to file 1 indicating if its address can be found in file 2. This is giving me a headache!
I can easily union the data, and the output the files that match. I can then create a new field using the formula tool which indicates the match. Obviously, 100% of the output is a match. My problem is I want to see not just the matches, but the whole dataset with an additional field indicating if its a match.
I know this is easy...I'm just at a wall! Any ideas?