Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

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

Finding the Minimum Date based on existance of a Value

AJ
6 - Meteoroid

Hello, this should be a straightforward transformation, but I'm overthinking the logic, so here it is. I want to create a Column into the flow of the dataset and call it, for ex, "HistoryDate" out of the following:

If the Amount column has any $$$ Value, I want this new column "HistoryDate" to display the Oldest Date out of the History_Created_Date column. Attached is a sample of data on what I'm looking to accomplish.

So for InvoiceNumber 00640lQAQ, the Historydate is expected to be 09/26/2021; for InvoiceNumber y00435uuh, the HistoryDate Expected to be 12/29/2021, and so on.

 

Thanks,

AJ

2 REPLIES 2
FinnCharlton
11 - Bolide

Hi @AJ ,

Think you're looking for something like this?:

FinnCharlton_0-1674672531608.png

 

AJ
6 - Meteoroid

Thanks so much.

Labels