Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Idea for Comparison Flow

CMCesar
6 - Meteoroid

Hey Alteryx community! 

 

Question to anyone who has a second. I will be doing a monthly report on costs of items my company buys. Every month I will pull the same report again and compare any price changes from the prior report. Would anyone have any good tips or advice on tools that can provide some good help in building out a flow? 

1 REPLY 1
JosephSerpis
17 - Castor
17 - Castor

Hi @CMCesar essentially what you want to do is join the data together on the items from the previous month and ensuring they are comparable such as comparing apples against apples and then you can compare the price. The join tool will be needed and any difference in price would come out of the left and right outputs from the tool. Any items that were the same price would come out from the J output. 

Labels
Top Solution Authors