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
Solved! Go to Solution.
Thanks so much.