How to compare two datasets with one column in common

Question

Hi everyone,

I'm looking to compare two datasets such as:

First excel dataset A has:

Column A - with a list of clients

Column B - with a list of employees within these clients

Column C - with a list of revenue generated per employee within these clients

Second excel dataset B has the same format.

My goal is to have the output as the following:

Column A - list of clients

Column B - list of employees from dataset B within clients from column A

Column C - list of revenue generated per employee from dataset B

Column D - list of employees from dataset A

Column E - list of revenue generated per employee from dataset A

Let me know if that's unclear and I can provide a visual example!

Thank you!

Steve

Stevebobs · Answer

Hi @Binuacs,

Sure, here it is.

Best,
Steve

Alteryx Forum Example.xlsx

Stevebobs · Answer

Hi @Robin_McIntosh,

Thanks for the reply! :)

That's the idea - in an ideal world:

With a top or bottom row that sums up the revenue per client, and also with matching employees on the same rows for an easier comparison. See screenshot:

Best,
Steve

binu_acs · Answer

@Stevebobs Can you provide sample input files and expected output result in an excel?