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!
Solved! Go to Solution.
Worked like magic. Thank you very much!
@wy_403411 take a look at 2 alternatives I've prepared.
They may be faster, which is not insignificant with 40 million rows.
Good luck!
Thank you very much! Both worked well for my task!
Much appreciated.
User | Count |
---|---|
35 | |
27 | |
8 | |
7 | |
7 |