Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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