Hi All,
I have an audit table that records the change to an account's information. I need to look up the most recent datetime and street address for the account only when the street_updated column is True and look it up by the cust_id.
In the example dataset below, I would expect my lookup output to be
cust_id: ABC1
datetime : 4/3/24 6:22 PM
street: 123 Forest
cust_id: ABC2
datetime : 4/3/24 6:22 PM
street: 789 Forest
Screenshot 2024-04-25 at 6.11.00 PM.png
Bookmarks