Merge two files based on common column

Question

Hi,

I have two data files with a common field, Client ID. This ID is common between the two files however the other columns are not. I want to combine the files to bring in some of the columns from the second file matched by client ID, e.g simplified.

File 1:

ID   Name

1    X

2    Y

3    Z

File 2:

ID  Revenue

1    500

2    600

3    900

I would want to bring the revenue in as a new column within file 1 so the revenue is matching based off the client ID.

Thanks,

Will

OllieClarke · Answer

Hey @WilliamParker

You'll want to use the Join tool to do this. There's a good article about it here: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Join/ta-p/29814

Or you can look in the sample workflows in alteryx if you wanna play with it too 🙂

Ollie

Luke_C · Answer

Hi @WilliamParker

You would use a join tool to accomplish this:

New Workflow2.yxmd