Finding shared values in two files

[45179902]

I have manually entered Addresses in two files. These files will be used to output letters. Before that, I must make sure there're no duplicate addresses. If there're are, I want to keep only one of those records. These files have a shared column but has different number of records. Using a Join would leave the ones that don't match off. I will need to send out letters for all records. Hope that you can come up with something using this hilarious example data:

File 1

Property Name	Property Owner	Property Address
Apple House	Apple	R101 NO 18 Apple Rd
Orange House	Orange	R301 NO 17 Orange St
Grape House	Grape	R101 NO15 Grape Ave

File 2

Property Name	Property Owner	Property Address
Apple House	Apple	R102 NO 18 Apple Rd
Orange House	Orange	R301 No. 17 Orange Street
Banana House	Banana	R100 NO.15 Banana Ave

Results should be

Property Name	Property Owner	Property Address
Apple House	Apple	R101 NO 18 Apple Rd

Orange House

Orange

R301 NO 17 Orange St

Apple House

Apple

R102 NO 18 Apple Rd

Banana House

Banana

R100 NO.15 Banana Ave

[saveeshkumar]

Hi GeorgeL,

You can the Join tool to get the below output.

L-[#1] - > Gives you Unmatched Records from Left Table

J-[#2]->  Gives you Unique records

R-[#3]-> Gives you unmatched records from Right Table 

Union Tool give you desired output.

Hope this helps you.

Thank you.

[45179902]

Hi, @saveeshkumar Thank you for your response. But your output is different from my expectation. If there're duplicates, I need to keep at least one of the records as shown in my desired output. There should be two Apple.

[saveeshkumar]

Hi @45179902 ,

Oops,my mistake in understanding it right..

I have made some changes for property address column using formula.

Hope this help you.

thanks.