I have some price data (~40million rows) and I want to know when the price changes. The data looks like this.
Each row represents an item sold at a particular store, and each column represents the price of that item if a transaction has occurred. The empty cells suggest that there is no transaction for that item at that store in that month.
I want to know highlight the months that an item changes the price for each store. For example, if the price is different from the prior non-null column, then "Yes". If the price is the same or empty, then "No" price change.
Is there a way to do this in Alteryx?
Thanks!
