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
20 - Arcturus

@hellyars 

binuacs_0-1646170979304.png

 

Qiu
20 - Arcturus
20 - Arcturus

@hellyars 
 A slightly different approach.

0302-hellyars.PNG

Labels