Select a Date Based on Condition without Creating Another Table

[ChrisIgnyte]

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.

[tackytechtom]

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/

[ChrisIgnyte]

This is close. Ideally, I would like it to fill all the way down for application_id.