Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

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

cdahl001
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

 

 

 

 

 

2 REPLIES 2
danilang
19 - Altair
19 - Altair

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

cdahl001
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