This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.