Add columns from one table to another table so data lines up to the key field

[ptopkis]

Greetings. 

I need help getting data into input to export to file for Tableau. Right now I have two tables. One has required training. The other has completed training. They can be linked using a common ID. What I need to do is add the completed columns to a table with the required info so the information lines up to the correct idea. I tried JOIN and UNION without success. 

They are in TWO separate files so I'm trying to use Alteryx to automate creating the file on a daily basis. 

So Data file 1 looks like this

ID	Role	Req Training 1	Req Training 2	Req Training 3
A	Lead	x	x
C	Mgr	x	x	x
B	Tech			x

Data file two looks like this

ID	Complete Training 1	Complete Training 2	Complete Training 3
A	2017
C
B			2017

I want it to end up like this:

ID	Role	Req Training 1	Req Training 2	Req Training 3	Com Train 1	Com Train 2	Com Train 3
A	Lead	x	x		2017
C	Mgr	x	x	x
B	Tech			x			2017

Join is giving me this:

ID	Role	Req Training 1	Req Training 2	Req Training 3	ID	Com Train 1	Com Train 2	Com Train 3
A	Lead	x	x
C	Mgr	x	x	x
B	Tech			x
					A	2017
					C
					B			2017

Union is giving me this:

ID	Role	Req Training 1	Req Training 2	Req Training 3	Com Train 1	Com Train 2	Com Train 3
A	Lead	x	x
C	Mgr	x	x	x
B	Tech			x
A					2017
C
B							2017

Thank you

[nick_ceneviva]

Join should do what you are looking for.  The attached workflow has the join and your desired output.  Please let me know if you have any questions

[ptopkis]

That provides an inner join. Is there a way to an outer join? Not all the data in one set is in the other set. 

[DavidxL · Accepted solution]

You can use a Union on the different output tabs of the Join. e.g. L+J = LEFT OUTER join

[ptopkis]

I found this that helped explain what you shared:

https://help.alteryx.com/10.0/index.htm#Join.htm#OtherJoins

---

---

[GideonM]

@ptopkis - thank you sharing this link, really helpful.