Idea for Comparison Flow

CMCesar

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? 

JosephSerpis

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.