Forum Discussion
Select a Date Based on Condition without Creating Another Table
Below is a sample of my data: application_id-status_code-status_date 00001-020-09/25/2021 00001-025-12/31/2021 00002-061-01/05/2022 00002-020-06/01/2021 I am trying to add a new column id...
Hi ChrisIgnyte ,
Not sure whether I am on the right track, but are you looking for something like this?
Here the code:
TomsStatusColumn = IF ( Table[status_code] = 20, Table[status_date], BLANK() )
Does this help? 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
This is close. Ideally, I would like it to fill all the way down for application_id.
