Appends Tool - Two Data Sets to One

[edmund_belleza]

Morning,

I have two data sets. Set #1 lists Associate Number with their Department. Set 2 lists Department and Apps required for each department.

I want to Export a data set that will list, by row, each associate and which App they require based on the Department they are assigned. I was trying to use the Append Tool, but I may not have set it up correctly as it's creating way more rows then expected. Perhaps I'm going about this the wrong way?

See below for what I'm trying to create. 

Input Set 1: Associate Info			Input Set 2: Department App Needs			Export: Associate App Needs
Associate	Department		Department	Application #		Associate	Department	Application #
ID001	Dept A		Dept A	App 1		ID001	Dept A	App 1
ID002	Dept A		Dept A	App 2		ID001	Dept A	App 2
ID003	Dept B		Dept A	App 3		ID001	Dept A	App 3
ID004	Dept B		Dept A	App 4		ID001	Dept A	App 4
			Dept A	App 5		ID001	Dept A	App 5
			Dept A	App 6		ID001	Dept A	App 6
			Dept A	App 7		ID001	Dept A	App 7
			Dept A	App 8		ID001	Dept A	App 8
			Dept B	App 3		ID002	Dept A	App 1
			Dept B	App 6		ID002	Dept A	App 2
			Dept B	App 8		ID002	Dept A	App 3
			Dept C	App 3		ID002	Dept A	App 4
			Dept C	App 4		ID002	Dept A	App 5
			Dept C	App 3		ID002	Dept A	App 6
						ID002	Dept A	App 7
						ID002	Dept A	App 8
						ID003	Dept B	App 3
						ID003	Dept B	App 6
						ID003	Dept B	App 8
						ID004	Dept C	App 3
						ID004	Dept C	App 4
						ID004	Dept C	App 3

[abacon · Accepted solution]

@edmund_belleza Use a join tool on the Department field. That will get the desired output.

Bacon

[edmund_belleza]

Thank you! I clearly got my Tools confused. Thanks for taking the time to respond!