Formula or Tool to join two different workflows

[geeklarokcmie]

What tool or formula should I use to calculate the below two workflows and create a new column? I use Vlookup in Excel - wasn't sure, what needs to be used in Alteryx. Thank you

Example below:

Workflow 1:

Summary	Ticket#	Application
John Doe	123	Accounting
Jane Doe	456	Fund Evaluator
Jill Doe	789	Ledger

Workflow 2:

Business	Application
Annuity	Fund Evaluator
Finance	Accounting
Finance	Ledger

Desired Output:

Summary	Ticket#	Application	Business
John Doe	123	Accounting	Finance
Jane Doe	456	Fund Evaluator	Annuity
Jill Doe	789	Ledger	Finance

[cjaneczko · Accepted solution]

The join tool would be the tool to use. You would join Application from WF1 to Application in WF2. 

[nagakavyasri · Accepted solution]