SOLVED
Project Doubt
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
satkis
6 - Meteoroid
‎07-20-2020
09:05 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Database Connection
1 REPLY 1
17 - Castor
‎07-20-2020
11:58 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
