Combining two data sets using two different fields

MikiA

Hello,

I would like to find a solution to combine two datasets based on two unique fields. Tried Fine/Replace Tool and Join but did not manage to get a desired outcome.

My scenario:

Dataset A:

UserID	AddressID	Preferred sports	Preferred fruits
123456		Football
	DEF	Volleyball

Dataset B: 

UserID	AddressID	Preferred sports	Preferred fruits
123456			Apple
	DEF		Banana

Expected outcome:

UserID	AddressID	Preferred sports	Preferred fruits
123456		Football	Apple
	DEF	Volleyball	Banana

abacon

@MikiA A combination of Join and a Formula tool is your best option here.

Bacon

JoinWorkflow.yxmd