First date by person

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.

Thanks,

Mark

Datasets

Accepted answers

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

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

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.

Thanks for your quick response and solution, Jonathan 🙂