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 IDRoleReq Training 1Req Training 2Req Training 3ALeadxx CMgrxxxBTech x Data file two looks like this IDComplete Training 1Complete Training 2Complete Training 3A2017 C B 2017 I want it to end up like this: IDRoleReq Training 1Req Training 2Req Training 3Com Train 1Com Train 2Com Train 3ALeadxx 2017 CMgrxxx BTech x 2017 Join is giving me this: IDRoleReq Training 1Req Training 2Req Training 3IDCom Train 1Com Train 2Com Train 3ALeadxx CMgrxxx BTech x A2017 C B 2017 Union is giving me this: IDRoleReq Training 1Req Training 2Req Training 3Com Train 1Com Train 2Com Train 3ALeadxx CMgrxxx BTech x A 2017 C B 2017 Thank you

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

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

Database Connection

Accepted answers

DavidxL

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

OuterJoin.yxmd

All comments

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

Join.yxmd

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.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280