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 |
Solved! Go to Solution.
The join tool would be the tool to use. You would join Application from WF1 to Application in WF2.