Project Doubt

[satkis]

Hi All,

In the attached worksheet, I have data which belongs to Report A and Report B, where in I am trying to use Alteryx for clubbing the data, so that to identify the differences between Report A and Report B.

However, I couldn't identify exact tool to do that, can someone help me on this?

Regards,

Satya Kishore

[DavidP · Accepted solution]

Hi @satkis 

In this case you would join the datasets based on Name. In the join tool you can rename Amounts to reflect Amount-A and Amount-B.

The you can use a formula tool to find the difference. Example attached.