Hi, I am new here!
I have a dataset that has data on multiple rows for the same patient with different encounter dates. I want to only see the unique patient once (so patient ID is the identifier) and show me only the most recent encounter date. Example data:
John Doe, Patient ID 1, encounter date 1/3/2022
John Doe, Patient ID 1, encounter date 3/5/2022
Jane Doe, Patient ID 3, encounter date 10/1/2022
John Smith, Patient ID 2, encounter date 3/1/2022
John Smith, Patient ID 2, encounter date 1/5/2022
John Smith, Patient ID 2, encounter date 6/4/2022
I have tried grouping methods in ETL and that hasn't worked. Can someone please help me?