We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Output only most recent date and price pair

hellyars
13 - Pulsar

 

Item records have two price fields  Price_1 on Date_1 and Price_2 on Date_2.  Price_2 and Date_2 may be null.  See Starting Data below.

 

I want to extract only the most recent date and price pair for a given item.  See Desired Output below.

 

 

Starting Data

ItemDate_1Price_1Date_2Price_2

Tacos

2012-12-314.322022-03-016.75
Bike2018-05-048945.99NullNull

 

Desired Output

ITEMDate (Most Recent)Price (Most Recent)
Tacos2022-03-016.75
BikeBike8945.99
2 REPLIES 2
binuacs
21 - Polaris

@hellyars 

binuacs_0-1646170979304.png

 

Qiu
21 - Polaris
21 - Polaris

@hellyars 
 A slightly different approach.

0302-hellyars.PNG

Labels
Top Solution Authors