Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop 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
13 - Pulsar

Hi @AJ ,

Think you're looking for something like this?:

FinnCharlton_0-1674672531608.png

 

AJ
6 - Meteoroid

Thanks so much.

Labels