Alteryx designer Discussions

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

Getting data from a previous date after filtering to a later date

Highlighted
7 - Meteor

Hello! I am trying to get the price of an item before it was put on markdown, but I have to filter the data to a certain date to see what price type it is first. While the filtered date is set, the dates the retail type happens can vary greatly. What do I need to put here to get the previous price? 

 

Screenshot Furmula tool.JPG

 

 

 

 

 

Highlighted
17 - Castor
17 - Castor

hi @cdahl001 

 

In order to access values on other rows, you need to use the Multirow tool.

 

w.png

 

You also need to make sure that your data is sorted in the proper order, in this case by Item, Store and Start.  Once sorted, the multirow tool can access the value from the previous row giving an output that looks like this

 

r.png

 

With this method, you can set the WasPrice for every item that had rollback without filtering on the dates 

 

Dan

Highlighted
7 - Meteor

You're the man, Dan!

 

I keep forgetting the usefulness of sorting data into a funnel and then applying a formula that checks each row. It's working great now. 

 

 

Screenshot Formula tool.JPG

Labels