Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Project Doubt

satkis
6 - Meteoroid

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

1 REPLY 1
DavidP
17 - Castor
17 - Castor

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.

 

DavidP_0-1595314728780.png

 

Labels