We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

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

Help with multi-column formula

wy_403411
5 - Atom

I have some price data (~40million rows) and I want to know when the price changes. The data looks like this. 

wy_403411_2-1629923843401.png

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. 

wy_403411_3-1629923978000.png

Is there a way to do this in Alteryx? 

Thanks! 

 

 

4 REPLIES 4
Drussek
9 - Comet

I think it will do the job.

wy_403411
5 - Atom

Worked like magic. Thank you very much! 

Drussek
9 - Comet

@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!

wy_403411
5 - Atom

Thank you very much! Both worked well for my task! 

Much appreciated. 

Labels