First date by person

[MJep]

Hi Everyone!

How do you filter a dataset to reflect only the first piece of data by date for a ID / person?

I have mocked up the below data as an example. In reality the dataset is 10k+ lines.

Name	Date
Mark	01/01/2020
Mark	01/02/2020
Joy	01/01/2020
Frank	04/04/2020
Joy	01/02/2020
Frank	09/09/2020

Thanks,

Mark

[Jonathan-Sherman · Accepted solution]

Hi @MJep,

You'll want to sort and sample your data to take the first row for each Name (use the group by function on the Sample tool)

If this solves your issue please mark the answer as correct, if not let me know! I've attach my workflow for you to download if needed.

Regards,

Jonathan

[Emil_Kos]

Hi @MJep,

I think you can just sort the data and use sample function.

Please find attached example. If that is not the desired output plus provide us with example of it.

[MJep]

Thanks for your quick response and solution, Jonathan 🙂