In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Extract Recent Data

YXM1012
5 - Atom

Hello everyone,

 

I appreciate your help with the following case:

1. I have historical data of price change for different products:

Yessica1_1-1613568950981.png

I would like to consolidate the data by product showing the current price "Base Price" and most recent "promo price" for each product)

Yessica1_0-1613568816842.png

Note: The base price doesn't have an end date.

 

Thanks in advance!

 

1 REPLY 1
mbarone
16 - Nebula
16 - Nebula

Have you tried anything using the Filter tool, Summarize tool, and Crosstab tool?  

Labels
Top Solution Authors