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 identifying the dates where the status code is equal to "020". I can do this by creating a new table and relating the two tables together, but I would like to avoid creating a new table.
2 Replies
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.
